Oracle查询优化技术在标准化服务平台中的应用

Application of Oracle query optimization technology in standardized service platform

系统数据量的增加,使得系统响应时间和系统吞吐率达不到要求,直接关系到系统性能和用户体验,因此对查询进行优化显得至关重要。以标准化服务平台系统应用开发为例,详细阐述了针对特定业务需求背景下的三种Oracle查询优化策略:基于Oracle全文索引,提高题录查询速度;基于Oracle快速刷新物化视图技术,提高年检查询速度;基于Oracle的Job定时任务,自动修改标准状态。

The increment of system data volumes makes response time of the system and throughput can not meet the requirements. It is related to system performance and user experience directly, so the query optimization is critical. Based on standardized application development platform system, according to the background of the specific business requirements, this thesis expounds three Oracle query optimization strategies ： based on Oracle full-text indexing to improve index query speed; based on fast refresh materialized view of Oracle technology to improve the query speed of annual inspection; based on Oracle job timing task to modify the standard state automatically.