Oracle查询优化技术在电信业务报表系统中的应用

Application of Oracle Query Optimization in Telecom Operations Report System

通过对电信业务报表系统查询特点的分析,结合Oracle的查询优化技术,探讨如何解决前台查询的快速响应以及后台大数据量分类统计的速度问题,并用之于实际系统的实现。

This paper analyzes the property of query in telecom operations report system,discusses how to solve the question about the response of rapid query and the speed of mass query based on Oracle query optimization,and successfully applies it to a system.