摘要： 用惯了delete语句是delete from tablename where ....今天要强制使用某一个index，查了查sql server也可以像ORACLE一样用hint，在select语句中是select * from tablename with(index(indexname)) where...可在delete中用delete from tablename with(index(indexname)) where ...出错。Google了很久终于找到一篇：http://social.msdn.microsoft.com/forums/en-US/transactsql/th 阅读全文