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.

Source : Roberto Stefanetti Blog
Read more…