Table Information including Index information (Usage, Blocks and Reads) – Again

In summary: This query shows a list of all tables and indexes in a SQL database to help identifying in which tables the most blocks happen, and to give a starting point for index tuning. For further details, refer to the original blog post.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…