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
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.
Hope this helps as well.
Thanks.
ZHU
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.
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,748
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
