Home > Database > Mysql Tutorial > 分析SQL Server 给出的missing index建议

分析SQL Server 给出的missing index建议

WBOY
Release: 2016-06-07 17:37:01
Original
1767 people have browsed it

测试基于SQLServer2008AdventureWorks2008,TablePerson.Person.表中已经存在的索引定义:CREATENONCLUSTEREDINDEX[IX_Person_LastName_FirstName_MiddleName]ON.

 

测试基于SQL Server 2008  AdventureWorks2008,TablePerson.Person.表中已经存在的索引定义:

 

 

 

 [ix1]

 [ix_firstname]

go


所以即使SQL Server给出的Missing Index 也要最好分析之后进行使用。创建Index之后要关注Index的使用状况,比如Seek/Scan/Lookup/Update的比例,根据这些数据,进行相应的调整。因为对于更新多而查询非常少的案例,创建多的索引可能会在造成负担。

 

 

 

 

本文出自 “关注SQL Server技术” 博客,请务必保留此出处

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template