Oracle数据库中大型表查询优化的研究

Research on Query Optimization to Large Sheet in Oracle Database

对海量数据进行访问查询时 ,常常遇到系统响应时间过长 ,占用系统资源过多的问题。本文结合实例着重对 Oracle数据库中的查询优化进行了研究 ,测试结果表明采用的方法是很有效的 ,大大缩短了测试用例表的响应时间 ,最后对海量数据的优化方法提出了实用性的建议。

When huge data are visited and inquired, such problems often occur as the time of system echo too long and system resource occupied too much. In this article, a research is exclusively made on query optimization in oracle database based on illustration, and the test result shows the adopted method is efficient, greatly reducing the echo time of the example sheet for test. Finally, some practical suggestions is proposed on optimization method to huge data.