SET STATISTICS IO ON
SET STATISTICS TIME ON
EXEC sp_executesql N'
SELECT *
FROM dbo.Item
WHERE id = @Id
AND code = @Code', N'@Id varchar(36),@Code varchar(36)', @Id = '01',
@Code = '001'
Item表联合主键id(varchar)和code(varchar),并建立了索引。
执行以上查询语句时
由于添加了索引,逻辑读取仅为2次
而修改代码为
SET STATISTICS IO ON
SET STATISTICS TIME ON
EXEC sp_executesql N'
SELECT *
FROM dbo.Item
WHERE id = @Id
AND code = @Code', N'@Id