I have a question regarding the indexes views and the real usage of them. I found a script on the internet that determines the user_seeks, user_updates, etc. for each
index and also the VSIFT indexes of the indexed views.
In a few tables I see that for user_seeks and user_updates (sys.dm_db_index_usage_stats) are the same but the values user_lookups and user_scans are zero.
This seems to me a little bit fishy. Can maybe somebody explain to me if this really means that I can drop these indexed views, they are decreasing heavily the index performance in the tables.
Thanks in advance,