成都大学学报(自然科学版)2016,Vol.35Issue(4):358-360,367,4.
Oracle 分区表和分区索引在 VLDB 中的研究
Research on Oracle Partitioned Table and Partitioned Index in VLDB
赵卫东 1刘永红 2鄢涛 1于曦2
作者信息
- 1. 成都大学模式识别与智能信息处理四川省高校重点实验室,四川成都 610106
- 2. 成都大学信息科学与工程学院,四川成都 610106
- 折叠
摘要
Abstract
Partitioned table and partitioned index are the key technologies in database management .They serve as important mechanisms to improve the performance of Very Large Databases (VLDB ) .The principle of partition technology is to separate a large table of logic into a plurality of independent physical partitions to store ,and thus to improve the performance of data I/O .In the face of a large number of data storage ,al-most all of the Oracle database use partition technology to improve the performance of data query .This arti-cle analyzes a project case and then illustrates how to use the partitioned table and partitioned index to im-prove the query speed of large data .关键词
Oracle/分区表/分区索引/VLDBKey words
Oracle/partitioned table/partitioned index/VLDB分类
信息技术与安全科学引用本文复制引用
赵卫东,刘永红,鄢涛,于曦..Oracle 分区表和分区索引在 VLDB 中的研究[J].成都大学学报(自然科学版),2016,35(4):358-360,367,4.