I'd like to see some type of formula that would determine the efficiency of a particular index, e.g. (pseudo-code)
If (user_seeks <> '0') and (user_scans/user_seeks > 0.5)
output 'Verify Index' , Table_Name, Index_Name
I'm still researching what ratios of what categories are significant.