使用索引来提高查询的执行速度 [英] using index to increase on execution speed of queries
问题描述
我试图实现索引功能以提高性能但是在将这些索引添加到列后我似乎没有任何速度差异
这里是我所做的.. 。
CREATE INDEX MYINDEXl ON员工(employee_name,city,)
CREATE INDEX MYINDEX2 ON销售额(数量,sales_Person)
当我讨厌这些表格时,在添加这些索引之前和之后似乎没有任何速度差异,或者它们应该以特殊方式执行。
其次我需要知道如何创建有效的索引
群集和非群集索引之间的区别是什么?
谢谢大家
I have tried to implement a feature of indexes to improve performance but after adding these indexes to column i don't seem to be getting any difference in speed
here is what i have done...
CREATE INDEX MYINDEXl ON employee (employee_name,city,)
CREATE INDEX MYINDEX2 ON sales(qty,sales_Person)
when i querry those tables i don't seem to get any difference in speed before and after adding these indexes or they are supposed to be executed in a special way.
secondly i need to know how i can create indexes that will be effective
What is the difference between clustered and non clustered indexes??
thanks guys
推荐答案
为什么不让管理工作室告诉你缺少什么?这是一个好的开始。查看链接以获取更多信息。
http://www.mssqltips.com/sqlservertip/1945/missing-index-feature-of-sql-server-2008-management-studio/ [ ^ ]
祝你好运!
Why don't you let the management studio tell you what's missing? It's a good start. Check the link for more info.
http://www.mssqltips.com/sqlservertip/1945/missing-index-feature-of-sql-server-2008-management-studio/[^]
Good luck!
这篇关于使用索引来提高查询的执行速度的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!