you need to capture execution plans that will include detail information on missing index recommanded by the query optimizer
set statistics profile 可以显示执行计划，当然可以看出来有没有用到索引
给出的答案是 set statistics showplan_xml_on好似乎没有这个命令吧？
------解决方案--------------------
嗯，不懂。
------解决方案--------------------
选项真多
------解决方案--------------------
set showplan_xml on
多写了statistics