| Oracle数据库中SQL查询优化的研究 |
| |
| 引用本文： | 张娅妮. Oracle数据库中SQL查询优化的研究[J]. 吉林工程技术师范学院学报, 2013, 29(6): 70-72 |
| |
| 作者姓名： | 张娅妮 |
| |
| 作者单位： | 黔南民族师范学院计算机科学系,贵州都匀,558000 |
| |
| 摘 要： | 现代社会科技的发展日新月异,各行各业都开始应用计算机管理软件提升工作效率。数据库的设计是各个管理软件的设计与实现中必不可少的,很多领域都有数据库信息存储与信息处理的技术应用。Oracle数据库是当前比较流行的数据库,SQL作为通用的、功能极强的通用数据库语言如果得到更好的优化,将使软件性能更加优化。本文主要从对于Oracle数据库SQL查询优化的重要性着手,从索引以及查询语句等优化方式进行分析,并且总结了一些Oracle数据库SQL查询优化技巧。
|
| 关 键 词： | Oracle数据库 SQL语句 查询 优化 |
Study on the Optimization of SQL Query in Oracle Database |
| |
| ZHANG Ya-ni. Study on the Optimization of SQL Query in Oracle Database[J]. Journal of Jilin Teachers Institute of Engineering and Technology(Natural Sciences Edition), 2013, 29(6): 70-72 |
| |
| Authors: | ZHANG Ya-ni |
| |
| Affiliation: | ZHANG Ya-ni(Department of Computer Science,Qiannan Normal College for Nationalities,Duyun Guizhou 558000,China) |
| |
| Abstract: | The development of modern science and technology is changing with each passing day,and all walks of life have begun to use the computer management software to enhance work efficiency.Database design is essential for the design and implementation of the management software,and there is technical application of database information storage and information processing in many fields.The Oracle database is currently more popular database;SQL as a general,powerful function general database language,if it is better optimized,will make the software performance more optimized.This article,starting from the importance of SQL query optimization of Oracle database,makes analysis from optimizing ways of indexing and query statement,and summarizes some of the Oracle database SQL query optimization techniques. |
| |
| Keywords: | Oracle database SQL statement query optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
