SQL语句的性能优化浅析 |
| |
引用本文: | 王晔.SQL语句的性能优化浅析[J].石油工业计算机应用,2007,15(3):28-30. |
| |
作者姓名: | 王晔 |
| |
作者单位: | 大庆油田有限责任公司财务资产部,黑龙江大庆163453 |
| |
摘 要: | 本文简要介绍了在应用Oracle数据库的过程中,作为数据结构式查询语言——SQL在书写过程中的一些优化方法,探讨了Oracle访问表数据的方式和索引的建立问题,从操作符、查询顺序、条件字段等方面比较分析不同写法对执行效率的影响,为数据库应用、开发人员提出优化方案和合理的书写建议。
|
关 键 词: | SQL 优化 查询语句 执行效率 建立索引 |
ANALYSIS OF THE PERFORMANCCE OPTIMIZATION OF SQL LANGUAGE |
| |
Abstract: | This paper proposed several useful optimized methods for SQL language in Oracle database manipulation,and discussed the pattern of table data access and establishment of index.It analyzed the effect of different writings on the execution efficiency from operational character,query sequence,condition field,etc.,which could provide optimized schemes and rational writing suggestions for developers. |
| |
Keywords: | SQL optimization query statement execution efficiency establishment of index |
本文献已被 维普 等数据库收录! |
|