While working on Index Analysis in SQL Server 2017,
I observed that
sys.dm_db_index_operational_stats not showing index is getting utilized(column name
range_scan_count, however when i checked same in DMV
sys.dm_db_index_usage_stats showing that
non-clustered index is getting utilized under column
user_seeks (For specific table on which i am trying to create
non-clustered index to gain the performance of query).
Not able to understand why there is difference ? Can somebody please help me to understand why it is so ?
- There is no any system/SQL Server service restarted during this activity, as well as database is not attached/detached.
- Creating Non-clustered index on table which is getting utilized in one of the function, that table is not getting utilized in anywhere in calling procedure (Main Procedure which is calling that function, having underline table).