I have a database that has 225 tables in it
What is the best way to find out / log which tables are used, and which are not ?
I would like to see something similar to below:
Table 1 - select 2222 times, insert 0 times, update 3 times, delete 0 times
Table 2 - select 1 times, insert 50 times, update 0 times, delete 5 times
Or in a below format:
Table 1 - select 2222
Table 1 - update 0
Table 2 - select 1
Table 2 - insert 50
Table 2 - delete 5
Best Answer
Remarks: sys.dm_db_index_operational_stats