Індекси, яких не вистачає в БД

SELECT migs.group_handle,
       mid.*,
       'CREATE NONCLUSTERED INDEX IX_'
       + Ltrim(Str(group_handle)) + ' ON '
       + mid.statement + ' (' + CASE WHEN equality_columns IS NULL THEN '' ELSE
       equality_columns + ' ' END + CASE WHEN inequality_columns IS NULL THEN ''
       ELSE
       ', '+ inequality_columns END + ')' + CASE WHEN included_columns IS NULL
       THEN ''
       ELSE ' INCLUDE (' + included_columns +') ' END AS create_index_script,
       avg_total_user_cost,
       user_seeks
FROM   sys.dm_db_missing_index_group_stats AS migs
       INNER JOIN sys.dm_db_missing_index_groups AS mig
               ON ( migs.group_handle = mig.index_group_handle )
       INNER JOIN sys.dm_db_missing_index_details AS mid
               ON ( mig.index_handle = mid.index_handle )
ORDER  BY avg_total_user_cost * avg_user_impact * ( user_seeks + user_scans ) DESC

Andriy Kravchenko

Admin, Writer, File Uploader

31.10.2024 21:16:15

SQL Server