To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL statement below; SELECT OBJECT_NAME(OBJECT_ID), mid.included_columns, mid.statement, mic.column_name, mid.equality_columns, mid.inequality_columns, mic.column_usage FROM sys.dm_db_missing_index_details mid CROSS apply sys.dm_db_missing_index_columns(mid.index_handle) mic ORDER BY mid.index_handle … Continue reading →