| 合理创建索引 实现数据库访问的优化 |
| |
| 引用本文： | 赵爱涛. 合理创建索引 实现数据库访问的优化[J]. 石家庄职业技术学院学报, 2013, 25(4): 24-26 |
| |
| 作者姓名： | 赵爱涛 |
| |
| 作者单位： | 石家庄职业技术学院信息工程系,河北石家庄,050081 |
| |
| 摘 要： | 数据库访问的效率是决定应用系统执行效率的关键因素之一.索引的设计应建立在对各种查询的分析和预测上.通过在Microsoft SQL Server 2008上对四种索引方案的测试,提出了利用索引优化数据查询的方法.在实际应用时,要根据系统的实际情况,权衡修改性能和检索性能的需求,选用合理的索引策略.
|
| 关 键 词： | 数据库 索引 优化 查询 Microsoft SQL Server |
Creating rational index for optimization of database access |
| |
| ZHAO Ai-tao. Creating rational index for optimization of database access[J]. Journal of Shijiazhuang Vocational Technology Institute, 2013, 25(4): 24-26 |
| |
| Authors: | ZHAO Ai-tao |
| |
| Affiliation: | ZHAO Ai-tao (Department of In[ormation Technology, Shijiazhuang Vocational Technology Institute, Shijiazhuang, Hebei 050081,C]aina) |
| |
| Abstract: | The efficiency of database access is a key to execution of efficiency. The designing of index should be based on the analysis and forecast of varied queries. By testing of the 4 indexing schemes on Mi- crosoft SQL Server 2008 DBMS,optimization is acquired for index database query. Hence,it is imperative to select the reasonable indexing strategy. |
| |
| Keywords: | database index optimization query Microsoft SQL Server |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
