摘要
本文将Oracle数据库的范围-列表组合分区表技术应用于广播监测数据的存储,从而改善了大数据的查询性能和维护管理,文章同时对分区表查询涉及的收缩表段、优化器和执行计划进行了基础性讨论。
In this paper, the composite range-list partitioned table of Oracle technology is applied in broadcasting monitoring data storage, which improves the query performance and maintenance management of big data. The paper discusses on segment shrink, optimizer and execution plan which are all involved in partitioned table query.
出处
《广播与电视技术》
2017年第11期113-118,共6页
Radio & TV Broadcast Engineering
关键词
ORACLE
组合分区表
查询
维护
Oracle, Composite partitioned table, Query, Maintenance