| 基于关系数据库的查询优化的方法研究 |
| |
| 引用本文： | 浦慧忠.基于关系数据库的查询优化的方法研究[J].长沙通信职业技术学院学报,2012,11(1):40-42. |
| |
| 作者姓名： | 浦慧忠 |
| |
| 作者单位： | 无锡高等师范学校,江苏无锡,214153 |
| |
| 摘 要： | 通常如何提高运行速度及执行效率是检验关系数据库系统性能好坏的重要标志,需要进行优化设计的地方很多,大体上有逻辑设计、物理设计和查询几个阶段。而相对于其他操作,查询操作所占的比重很大,因此可以说查询速度决定了关系数据库的性能优劣。文章重点讨论查询优化的一些方法,并结合它在实际应用中的例子进行分析。
|
| 关 键 词： | 关系数据库 查询 优化 索引 临时表 |
Research on query optimization methods based on relational database |
| |
| PU Hui-zhong.Research on query optimization methods based on relational database[J].Journal of Changsha Telecommunications and Technology Vocational,2012,11(1):40-42. |
| |
| Authors: | PU Hui-zhong |
| |
| Affiliation: | PU Hui-zhong(Wuxi Teachers＇ College,Wuxi,Jiangsu,China 214153) |
| |
| Abstract: | Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples. |
| |
| Keywords: | relational database query optimization index temporary table |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
