Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users, automatically | - | 
Apr 1, 2025 |
Business value
The enhanced Database Missing Indexes page provides you with deeper insights to optimize database performance. With new metrics, businesses identify opportunities to reduce query costs and improve system efficiency, resulting in faster operations and a better user experience. These enhancements provide tangible benefits, such as improved resource usage and cost savings.
Feature details
Use the Database Missing Indexes page to identify opportunities to improve database performance by adding indexes.
This release introduces new metrics to help you:
- 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).
Tell us what you think
Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.