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 gives you deeper insights to help you optimize database performance. With new metrics, businesses can see opportunities to reduce query costs and improve system efficiency. These improvements lead to faster operations and a better user experience. These enhancements bring clear benefits, including better resource usage and cost savings.
Feature details
Use the Database Missing Indexes page to find ways to improve database performance by adding indexes.
This release adds new metrics to help you understand the benefits of adding indexes:
- Seeks: Shows the number of seeks from queries that could use the suggested index.
- Scans: Shows the number of scans from queries that could use the suggested index.
- Average Total Cost: Displays the average cost of queries that the suggested index can lower.
- Average Impact: Displays the average percentage reduction in query costs when you add the suggested index.
- Estimated Benefit: Calculates the potential benefit of adding the suggested index with this formula: (seeks + scans) × (average total cost) × (average impact).
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.
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.