摘要
索引对于数据库的性能而言是至关重要的,因此索引设计与维护是数据库开发与运行中的重要任务。介绍了索引的概念,分析了两种主要的索引类型,并针对设计和运行两个阶段,对索引设计的原则、索引有用性的测试,以及运行中出现的典型问题的检测与维护处理进行了详细的探讨。
The index for the database performance is essential, so design and maintenance of the index is an important task. The concepts and two main types of indexes are analyzed. In terms of the design and operation, the followings are discussed in detail: principles of design, test of usefulness, check of typical problems, and the relevant solutions .
出处
《微型电脑应用》
2012年第11期29-31,共3页
Microcomputer Applications