在MS SQL中使用Like的非聚集索引
问题描述：
我创建一个表并在[名称]字段上应用非聚簇索引
如果我在非聚集索引[名称]的查询中使用像
如何运作?
是类似查询使用的非聚集索引吗?
I Create a table and apply Non Clustered index on [Name] field
if i use like in Query on non clustered index [Name]
how it works?
is Like Query used non clustered Index?
答
我不确定，但它应该可以工作....
i am not sure but it should work....
有一个请看下面的文章.
http://www.sql-server-performance.com/2007/optimizing-indexes-general /
Have a look at below Article.
http://www.sql-server-performance.com/2007/optimizing-indexes-general/
阅读以下有关索引的内容:
http://sqlserverplanet.com/indexes/sql-server-indexes-tutorial/ [ ^ ]
http://www.sql-server-performance.com/2004/index-data-structures / [^ ]
Read the following on indexes :
http://sqlserverplanet.com/indexes/sql-server-indexes-tutorial/[^]
http://www.sql-server-performance.com/2004/index-data-structures/[^]