计算机技术与发展2012，Vol.22Issue(2)：165-167,3.
基于Oracle数据库海量数据的查询优化研究
Query Optimization Research on Mass of Data Based on Oracle Database
摘要
Abstract
While database has large amount of data, the inquires will have a series of problems like system response time is too long and take up too many system resources. So the query optimization research on the mass of data based on Oracle database is necessary. It uses the various measures and methods to improve the response speed based on Oracle database such as reasonably designing the database structure, the use of the index .partition, SQL optimization method. In addition, pagination display the query results can also greatly improve query speed. Experiments show the optimization obviously improves the speed a lot.关键词
Oracle数据库/海量数据/查询优化Key words
Oracle database/the mass of data/query optimization分类
信息技术与安全科学引用本文复制引用
张辉,赵郁亮,徐江,孙伟华..基于Oracle数据库海量数据的查询优化研究[J].计算机技术与发展,2012,22(2):165-167,3.基金项目
国家十一五科技支撑计划项目(2008BAF31B01) （2008BAF31B01）
