首页 / 数据库 / SQLServer / SQL SERVER参数化查询后不走筛选索引

SQL SERVER参数化查询后不走筛选索引2014-08-14

DROP TABLE T_TESTCREATE TABLE T_TEST（ID INT IDENTITY PRIMARY KEY,STATUS BIT）INSERT INTO T_TEST SELECT 0GO 100000INSERT INTO T_TEST SELECT 1CREATE INDEX IXF_T_TEST_STATUS ON T_TEST（STATUS） WHERE STATUS=1UPDATE STATISTICS T_TEST with fullscanDBCC FREEPROCCACHE--正常查询SELECT * FROM T_TEST WHERE STATUS=1

--参数化查询
SP_EXECUTESQL N"SELECT * FROM T_TEST WHERE STATUS=@STATUS",N"@STATUS BIT",1

这让我情何以堪？