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

Notifications

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,708 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,708 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,708 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,111 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,111 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans