Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

Are there any negative impacts to dropping unique (Unused) indexes from a Navision (2015) database?

editSubscribe (0) ShareShare
ReportReport
Posted on by 5

Our team have found that there are number of unique indexes has 0 read but more writes. What impact will this have on the system as a whole if we remove those specific types of indexing for our tables ?

Navision version 2015 

Example : Index usage : Reads: 0 Writes: 123,095

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,873 Super User on at
    RE: Are there any negative impacts to dropping unique (Unused) indexes from a Navision (2015) database?

    Hi, I agree with Inge. But we've tried rebuilding indexes when we've had major performance issues. This requires detailed testing and is not recommended for implementation in a production environment.

    More details: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver16#rebuild-an-index

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    RE: Are there any negative impacts to dropping unique (Unused) indexes from a Navision (2015) database?

    In general i would be careful about removing indexes unless you have a specific performance problem in a part of the system or when running specific procedures.

    And i would discuss each index in detail with someone that knows the system well.

    In general removing indexes will speed up write operations and slow down read operations.  So for table with few reads and many writes less indexes usually means better performance.

    And remember that in Business Central every index is unique because they all have primary key as the last fields of the index if you add them through the development enviornment.

    There are also indexes that might be used only during periodic activities. Those indexes will now show up in a day to day logging but removing them can have a huge impact when those periodic activities run.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans