Alexander Suprun (1/28/2013)
ugo boy (1/28/2013)
I mean, if there are no searches done on the tablethen you should DROP these indexes.
Keep in mind these statistics are cumulative and only show information since the last time the MSSQL service was started. If you recently restarted the service and check this DMV, you may find many indexes that don't appear to be used...so be careful deleting them without first checking whether they're really needed or not.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience