| SQL Server数据库索引设计的研究 |
| |
| 引用本文： | 邓小善.SQL Server数据库索引设计的研究[J].中国科技信息,2006(22):148-150. |
| |
| 作者姓名： | 邓小善 |
| |
| 作者单位： | 永州职业技术学院网络技术系,425000 |
| |
| 摘 要： | 随着数据量的增加,如何提升数据库查询的性能显得越来越重要,而索引是解决该问题的有效方法.本文阐述了索引的分类与利弊,阐明了设计索引的一般原则及索引的应用场合,分析了设计索引时的注意事项.
|
| 关 键 词： | 聚集索引 非聚集索引 设计原则 应用场合 注意事项 |
On SQL Server Index Design |
| |
| Deng Xiaoshan.On SQL Server Index Design[J].CHINA SCIENCE AND TECHNOLOGY INFORMATION,2006(22):148-150. |
| |
| Authors: | Deng Xiaoshan |
| |
| Institution: | Deng Xiaoshan Network Technical Department of Yongzhou Vocational-Technical College Yongzhou Hunan 425000 |
| |
| Abstract: | With the increase of data, it is more and more important on how to improve the query ability of database. And index is the key method of solving the problem. This text illustrates the classification and advantages and disadvantages of index as well as the general principle of designing index and the application of index. In this article, the author also analyses some notes when designing index. |
| |
| Keywords: | Clustered index Noclustered index Designing index Application Notes |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
