Thanks rm. I have table with 9 indexes. But when I ran from dm_db_index_usage_stats that object Id it shows only 5 indexes.
select * from sys.dm_db_index_usage_stats
where object_id = 20271
Why it is not showing other 4 indexes.
Also, last_user_seek and last_user_scan columns are null what is this means?. I used following query.
select i.object_id,o.name,i.index_id,ind.name Index_Name,i.*
from sys.dm_db_index_usage_stats i, sys.objects o,sys.indexes ind
where i.object_id = o.object_id
and o.object_id = 20271
and ind.object_id = o.object_id
and i.index_id = ind.index_id