STAY IN TOUCH

Get New posts delivered straight to your inbox

  • Madeira Team

Redundant Indexes

This query returns redundant indexes.

An index is considered redundant if there is at least one other index for the same table or view which contains at least the same index keys (in the same order) and at least the same included columns. This query compares only non-clustered indexes, and it does not take into account the uniqueness of the indexes as well as the filter condition of filtered indexes (although it displays this information for each index).


For more information about this script: http://madeira.sqlserverradio.co.il/get-rid-of-redundant-indexes/

#indexes #performancetuning #performancetuningservice #maintenance

JOIN OUR MAILING LIST

CONTACT US

 3 Rapaport St. Kfar Saba, Israel

 +972-9-7400101

  • Google+ - White Circle
  • Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle