在阐述SQL Server索引结构和类别的同时,讨论了在SQL Server中建立索引对数据库性能的影响,以及建立索引时需要注意的事项,最后从索引检测、索引修复等方面论述了索引维护。
This paper describes the SQL Server index structure and categories,and discusses using indexes to improve database performance,as well as the notes which matter in creating index,and finally discusses index maintenance from the index detection and the index repair.