web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Can DB admin drop non-...
Small and medium business | Business Central, N...
Answered

Can DB admin drop non-clustered index in Dynamic 365 BC?

(0) ShareShare
ReportReport
Posted on by Hoang_NguyenQuoc 25

I have question about dropping non-clustered index in D365 BC. will it affect the accuracy of the data?

Thank for your help

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,790 Moderator on at

    Hi Hoang_NguyenQuoc ,

    Disabling a clustered index has additional effects. The data in the table still exists, but will be inaccessible for anything other than a drop or rebuild operation. All related nonclustered indexes and views are also unavailable. Foreign key constraints that reference the table are disabled. Queries against the table will fail.

    Disabling a nonclustered index will deallocate the index pages – the space is freed in the database.

    The biggest difference between disabling and dropping a nonclustered index is whether the index definition stays around.

    To disable in index, issue an ALTER INDEX command.

    Source : docs.microsoft.com/.../disble-enable-indexes-vs-drop-recreate-during-bulk.html

  • Hoang_NguyenQuoc Profile Picture
    Hoang_NguyenQuoc 25 on at

    Thank for your responds.

    After dropping non-clustered index. the query take more time to respond

    Can I just easily re-create the index again depend on the previous structure instead of restore database

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,790 Moderator on at

    Hi,

    Are you using OnPrem version?

    Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the specified or existing fill factor setting, and reorders the index rows in contiguous pages.

    Source : www.beyondtrust.com/.../reorganize-and-rebuild-indexes-in-database.htm

    https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16

  • Hoang_NguyenQuoc Profile Picture
    Hoang_NguyenQuoc 25 on at

    thank for your respond

    Yes. my organization using on Premium version.

    you mean I can re-create non-clustered index instead of restoring database, right?

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,790 Moderator on at

    Ok

    Yes please follow the best advice from the Link I have shared and act accordingly, which is best for you DB, also I would recommend do the activity on Test DB first same replica of your source DB.

    Thanks.

  • Verified answer
    Hoang_NguyenQuoc Profile Picture
    Hoang_NguyenQuoc 25 on at

    Thank for your respond

  • Hoang_NguyenQuoc Profile Picture
    Hoang_NguyenQuoc 25 on at

    Does any one else who familiar with this, please give me some advice

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,161 Moderator on at

    If you want to drop a non clustered index in a Business Central database i would recommend you do it by changing the maintain on SQL property on the index instead of doing it directly on the SQL server.

    Please see the doc in the link.

    docs.microsoft.com/.../devenv-maintainsqlindex-property

  • Hoang_NguyenQuoc Profile Picture
    Hoang_NguyenQuoc 25 on at

    Thank for responding,

    The situation here is I already drop non-clustered index in system.

    The only thing I care about that I must restore DB or just re-create non clustered index

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,161 Moderator on at

    My approach would depend a little on what table you have been dropping indexes on.

    If it is on a table in the base application you can recreate the index, but try to give it the same name as it had originally.

    If it is in a customized table my approach would be to uninstall and then install the extension that the table is a part of.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,870 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,138 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 915 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans