Equality_columns, inquality_Columns and included_columns.....

• Tac11

  SSCertifiable

  Points: 6976

  More actions

  January 19, 2017 at 1:23 pm

  #317565

  Hi Experts
  Can someone please explain 3 columns equality_columns, inquality_Columns and included_columns from select * from sys.dm_db_missing_index_details.
  What are these and how do they help to trouble shoot indexes on a databases?
  when I run on a prod database Some equality_Columns and inequality_columns have 'Null' value and very few included_columns have 'Null', what are these things tryng to say?
  Thanks

• Thom A

  SSC Guru

  Points: 99126

  More actions

  January 19, 2017 at 2:00 pm

  #1923859

  Have you tried Googling this? MSDN has the answer: sys.dm_db_missing_index_details (Transact-SQL).

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk