SQL Server Management Studio
SQL実行
"New Query" / File->New->Query with...
SQL Server Management StudioでSQLを実行する方法 | SQLServer初心者でもスッキリわかる
ミリ秒計測(SSMSで)
set statistics time on <query> set statistics time off
で、"Message"タブを見る
インデックス確認
SELECT convert(varchar, i.name) AS index_name , convert(varchar, o.name) AS table_name , convert(varchar, col.name) AS column_name FROM sysindexkeys ik ,sysobjects o ,syscolumns col ,sysindexes i WHERE ik.id = o.id AND ik.id = col.id AND ik.colid = col.colid AND ik.id = i.id AND ik.indid = i.indid AND o.xtype = 'U' AND o.name in ('NodeInstanceLog', 'AuditTaskImpl') ORDER BY i.name ,ik.id ,ik.indid ,ik.keyno