Sql srv數(shù)據(jù)庫中,當運行這么一條查詢時
SELECT COUNT
( * )
FROM FNRev?
WHERE A IN ()
AND B IN (? )
AND C = 1
AND D= 9
AND E= 0
GROUP BY (F)
當已經(jīng)對A進行索引,但索引未生效時,有可能是其他字段的索引生效了,導(dǎo)致沒有使用A索引
此時可以使用WITH (INDEX ( A ))指定索引
SELECT COUNT
( * )
FROM FNRev?
WITH (INDEX ( A ))
WHERE A IN ()
AND b IN (? )
AND c = 1
AND d= 9
AND e= 0
GROUP BY (f)
