这个题目答案是不是错了?
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