Posted inDynamics NAV & BC Tips & tricks
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 :…