| 基于ORACLE数据库的SQL语句优化分析 |
| |
| 引用本文： | 郭霞.基于ORACLE数据库的SQL语句优化分析[J].数字社区&智能家居,2011(21). |
| |
| 作者姓名： | 郭霞 |
| |
| 作者单位： | 山东联通德州市分公司; |
| |
| 摘 要： | 随着数据库技术应用到各个学科领域,由于数据库规模的不断扩大,数据库系统的性能问题越来越突出,因此对数据库优化技术方法的探索,对确保数据库系统能否稳定、高效的运行有着至关重要的意义。该文针对Oracle数据库的SQL调整和优化,论述了SQL优化的目的和原则,并通过若干实例,介绍了SQL语句优化的一些方法。
|
| 关 键 词： | Oracle SQL 查询 优化 |
Based on ORACLE Database SQL Statement Optimization Analysis |
| |
| GUO Xia.Based on ORACLE Database SQL Statement Optimization Analysis[J].Digital Community & Smart Home,2011(21). |
| |
| Authors: | GUO Xia |
| |
| Affiliation: | GUO Xia(Dezhou City,Shandong Unicom Branch,Dezhou 253000,China) |
| |
| Abstract: | With the database technology to various disciplines,due to the constant expansion of the database,database system performance is increasingly prominent,so the optimization method to explore the database,the database system can ensure stable and efficient operation with of crucial importance.In this paper,Oracle SQL tuning and optimization of the database,discusses the purpose and principles of SQL optimization,and through a number of examples,describes some of the ways to optimize SQL statements. |
| |
| Keywords: | Oracle SQL query optimization |
| 本文献已被 CNKI 等数据库收录！ |
|
