本文首先介绍了Oracle的分区管理。先从分区的6个优点入手,分析了使用分区的原因和常用方法。着重介绍了基于量程的分区:影响分区键选择的三个因素和具体的SQL语句创建分区的过程。并从增加新的分区、删除分区、进行索引三方面论述了对分区的具体维护方法。之后,简单地论述了Oracle的一些优化方法。从数据字典、内部存储结构、索引、排序、导入与导出五个方面的优化方法进行论述。 Firstly, introducing the partition management of Oracle in this paper。Introducing six advantages of partition, in order to analyze the reason of using the partition and some methods using often。Emphatically introducing the measurement range partitioning: three factors of affecting the choice of partition key and the process of creating the partition using SQL。 Discussing the methods of safeguarding the partition by increasing new partition, drop old partition and using index。Then, simply expounding some methods of optimize Oracle。Discussing it by data directory, SGA, index, sort and I/O。 |
- 上一篇:论我国电子商务发展趋势
- 下一篇:计算机病毒预防技术探讨
查看评论
已有0位网友发表了看法