Business Central Onpremise – Create SQL Missing Indexes from AL
Through the page 9521 Database Missing Indexes it is possible to see the missing indexes suggested by SQL Server for Business Central (in fact, an SQL function is called which returns the missing indexes).
In this case the same function has been recreated on SQL (stored procedure) so that it can be launched both from BC (Onpremise) and from SQL.
For Business Central Online it is only…
Continue Reading rs’s Article on their blog
Business Central Onpremise – Create SQL Missing Indexes from AL
Through the page 9521 Database Missing Indexes it is possible to see the missing indexes suggested by SQL Server for Business Central (in fact, an SQL function is called which returns the missing indexes). In this case the same function has been recreated on SQL (stored procedure) so that it can be launched both from BC (Onpremise) and from SQL.
Blog Syndicated with rs’s Permission
More About This Author
Array
- Business Central11 April 2024MB-820 Beta – Microsoft Dynamics 365 Business Central Developer
- Business Central5 April 2024Business Central 24 Wave1 – Copilot Chat & Analyze List
- Business Central22 March 2024SQL Server: how-to check info about Indexes, Locks & Deadlocks
- Business Central22 March 2024Business Central 2024 release wave1 Launch Event – April 4-10