| Oralce数据库的SQL查询优化研究 |
| |
| 引用本文： | 周志德.Oralce数据库的SQL查询优化研究[J].计算机与数字工程,2010,38(11):173-178. |
| |
| 作者姓名： | 周志德 |
| |
| 作者单位： | [1]无锡职业技术学院,无锡214122 [2]江南大学,无锡214122 |
| |
| 基金项目： | 江苏省科技厅"青蓝工程"优秀青年骨干教师计划项目资助 |
| |
| 摘 要： | Oracle数据库的性能优化问题一直是决策者及技术人员共同关注的焦点,影响数据库性能的一个重要因素就是SQL查询语句的低效率。阐述了几种常见的Oracle数据库的性能优化技术,如数据库设计的优化、I/O优化、数据库各种动态参数的调整,并着重讨论了SQL语句的查询优化。从查询优化的测试结果来看,系统的响应时间明显降低,系统运行效率得到提升。
|
| 关 键 词： | Oracle数据库 性能优化 SQL查询 查询优化 |
Research on SQL Query Optimization of Oracle Database |
| |
| Zhou Zhide.Research on SQL Query Optimization of Oracle Database[J].Computer and Digital Engineering,2010,38(11):173-178. |
| |
| Authors: | Zhou Zhide |
| |
| Affiliation: | Zhou Zhide(Wuxi Institute of Technolgy,Wuxi 214122)(Jiangnan University,Wuxi 214122) |
| |
| Abstract: | The problem of Oracle database＇s performance optimization has been the focal point which the decision-maker and the technician show solicitude for commonly,and a key factor affecting the database＇s performance is that low efficiency of the SQL query sentence.Several kinds of common Oracle database＇s performance optimization techniques were elaborated,such as database design＇s optimization,I/O optimization,the adjustment of various dynamic parameters of database,and the SQL sentence query optimization was discussed emphatically.Judging from the results of query optimization test,the system＇s response time reduces obviously and the system＇s operation efficiency obtains the promotion. |
| |
| Keywords: | Oracle database performance optimization SQL query query optimization |
| 本文献已被 维普 万方数据 等数据库收录！ |
