| 基于ORACLE数据库查询优化方法研究 |
| |
| 引用本文： | 王兆丰,王昕.基于ORACLE数据库查询优化方法研究[J].国土资源信息化,2005(2):30-33. |
| |
| 作者姓名： | 王兆丰 王昕 |
| |
| 作者单位： | 中国地质大学，农业部信息中心 湖北武汉430074，国土资源部信息中心，北京100026 |
| |
| 摘 要： | 数据库最基本的任务是存储、管理数据,而终端用户唯一能看到的数据库特性就是其性能,其中数据库查询操作的效率是影响一个应用系统响应时间的关键因素。本文通过对ORACLE的使用,从命中率提高、多表查询优化、大表查询优化和SQL优化等四个方面阐述了ORACLE数据库查询效率提高的经验和方法。
|
| 关 键 词： | ORACLE 查询 命中率 SQL |
| 文章编号： | 4481-(2005)01-0030-04 |
| 修稿时间： | 2005年2月28日 |
Query Optimization Method of ORACLE Database |
| |
| Wang Zhaofeng,Wang xin China University of Geosciences,Wuhan,Hubei Province, Information Center,Ministry of Land and Resources,Beijing, Information Center,Ministry of Agriculture,Beijing.Query Optimization Method of ORACLE Database[J].Land and Resources Informatization,2005(2):30-33. |
| |
| Authors: | Wang Zhaofeng Wang xin China University of Geosciences Wuhan Hubei Province Information Center Ministry of Land and Resources Beijing Information Center Ministry of Agriculture Beijing |
| |
| Institution: | Wang Zhaofeng,Wang xin China University of Geosciences,Wuhan,Hubei Province,430074 Information Center,Ministry of Land and Resources,Beijing,100812 Information Center,Ministry of Agriculture,Beijing,100026 |
| |
| Abstract: | The basic tasks of a database are data storage and management, and the only characteristic of the database that terminal users can see is its capability. The query efficiency of a database is the key factor influencing the response time of the application system. This paper has elaborated the experiences and methods of raising the query efficiency of ORACLE database from the following four aspects: hit ratio improving, multi-table query optimizing, large tables query optimizing, and tuning of SQL statement. |
| |
| Keywords: | ORACLE Enquiry Hit ratio SQL |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
