With Business Central 2025 wave 1 Microsoft enhances the Database Missing Indexes page by adding a few new columns:
- Seeks: Tracks the number of seeks caused by queries that could have used the suggested index.
- Scans: Tracks the number of scans caused by queries that could have used the suggested index.
- Average Total Cost: Shows the average cost of queries that would decrease if the suggested index is added.
- Average Impact: Shows the average percentage reduction in query costs if the suggested index is added.
- Estimated Benefit: Calculates the potential benefit of adding the suggested index using the formula: (seeks + scans) × (average total cost) × (average impact).
In my latest video, I took a few suggested indexes and turned them into AL non-clustered keys to immediately see the impact:
========================================================
Buy my book:
https://leanpub.com/BCLedgerEntriesInsights
Download pdf sample:
========================================================
One Response