SQL server Missing index with change of impact in percentage
go /* Description:- This Query will provide you detail of missing indexes on a table and also prepare sql script for new index */ SELECT DISTINCT @@ SERVERNAME AS [ ServerName ] , DB_NAME () AS [ DatabaseName ] , SCHEMA_NAME ([ systemObject ].[ schema_id ]) AS [ SchemaName ] ,[ systemObject ]. Object_ID AS ObjectID , [ systemObject ].[ name ] AS [ ObjectName ] , CASE [ systemObject ].[ type ] WHEN 'U' THEN 'Table' WHEN 'V' THEN 'View' ELSE 'Unknown' END AS [ ObjectType ] , [ MissingIndexDetail ].[ equality_columns ] AS [ EqualityColumns ] , [ MissingIndexDetail ].[ inequality_columns ] AS [ InequalityColumns ] , [ MissingIndexDetail ].[ included_columns ] AS [ IncludedColumns ] , [ MissingIndexGroupState ].[ user_seeks ] AS [ ExpectedIndexSeeksByUserQueries ] , [ MissingIndexGroupState ].[ user_scans ] AS [ ExpectedIndexScansByUserQueri