| SQL Server索引的优化 |
| |
| 引用本文： | 苑卫国,迟呈英,钟菊. SQL Server索引的优化[J]. 鞍山科技大学学报, 2001, 24(4): 274-276 |
| |
| 作者姓名： | 苑卫国 迟呈英 钟菊 |
| |
| 作者单位： | 鞍山钢铁学院高等职业技术学院!辽宁鞍山114002(苑卫国，钟菊)，鞍山钢铁学院计算机科学与工程学院!辽宁鞍山114002(迟呈英) |
| |
| 摘 要： | SQLServer优化技术对提高系统性能至关重要 .为充分利用索引 ,优化表的查询机制 ,从而提高SQLServer查询速度 ,本文从建立有用的索引减少表扫描I O次数 ,优化WHERE子句避免列操作 ,合理应用复合索引选好第一索引列和使用聚集索引使数据在物理上按顺序排列四个方面加以阐述
|
| 关 键 词： | SQLSERVER查询优化器 表扫描 逻辑页IO 聚集索引 复合索引 |
| 文章编号： | 1000-1654(2001)04-0274-03 |
| 修稿时间： | 2001-06-20 |
Optimization of SQL Server Index |
| |
| YUAN Wei_guo ,CHI Cheng_ying ,ZHONG Ju. Optimization of SQL Server Index[J]. Journal of Anshan University of Science and Technology, 2001, 24(4): 274-276 |
| |
| Authors: | YUAN Wei_guo CHI Cheng_ying ZHONG Ju |
| |
| Affiliation: | YUAN Wei_guo 1,CHI Cheng_ying 2,ZHONG Ju 1 |
| |
| Abstract: | SQL Server optimizing technique is very important to improve system performance.The problem is how to make full use of index,to optimize the query mechanism of table,so as to increase SQL server query speed.This paper expounds following four points:first,establish useful index to reduce percent times of table scan;secondly,optimize WHERE clauses to avoid the operation of line;thirdly,make full use of multiplex index to choose the first index line,and last,make use of assemble index to let the data be lined in physical order. |
| |
| Keywords: | optimizing ware of SQL server query table scan logic page I/O assemble index complex index |
| 本文献已被 CNKI 等数据库收录！ |
|
