避免bookmark lookup的查询

select Age1 from Student where Name = '张三'
create nonclustered index Tw on Student(Name) include(Age1)

  

创建索引时,可以加上这个

include(Age1)
posted @ 2022-07-23 09:46  二维一加零  阅读(21)  评论(0)    收藏  举报