- 浏览: 70559 次
- 性别:
- 来自: 杭州
文章分类
最新评论
[转]Optimizing SPLIT PARTITION and SPLIT SUBPARTITION Operations
- 博客分类:
- Oracle
- Oracle SQL Tunning
Optimizing SPLIT PARTITION and SPLIT SUBPARTITION Operations
Oracle Database implements a SPLIT PARTITION operation by creating two new
partitions and redistributing the rows from the partition being split into the two new
partitions. This is an expensive operation because it is necessary to scan all the rows of
the partition being split and then insert them one-by-one into the new partitions.
Further if you do not use the UPDATE INDEXES clause, both local and global indexes
also require rebuilding.
Sometimes after a split operation, one of the new partitions contains all of the rows
from the partition being split, while the other partition contains no rows. This is often
the case when splitting the first partition of a table. The database can detect such
situations and can optimize the split operation. This optimization results in a fast split
operation that behaves like an add partition operation.
Specifically, the database can optimize and speed up SPLIT PARTITION operations if
all of the following conditions are met:
■ One of the two resulting partitions must be empty.
■ The non-empty resulting partition must have storage characteristics identical to
those of the partition being split. Specifically:
– If the partition being split is composite, then the storage characteristics of each
subpartition in the new non-empty resulting partition must be identical to
those of the subpartitions of the partition being split.
– If the partition being split contains a LOB column, then the storage
characteristics of each LOB (sub)partition in the new non-empty resulting
partition must be identical to those of the LOB (sub)partitions of the partition
being split.
– If a partition of an index-organized table with overflow is being split, then the
storage characteristics of each overflow (sub)partition in the new nonempty
resulting partition must be identical to those of the overflow (sub)partitions of
the partition being split.
– If a partition an index-organized table with mapping table is being split, then
the storage characteristics of each mapping table (sub)partition in the new
nonempty resulting partition must be identical to those of the mapping table
(sub)partitions of the partition being split.
If these conditions are met after the split, then all global indexes remain usable, even if
you did not specify the UPDATE INDEXES clause. Local index (sub)partitions
associated with both resulting partitions remain usable if they were usable before the
split. Local index (sub)partition(s) corresponding to the non-empty resulting partition
will be identical to the local index (sub)partition(s) of the partition that was split.
The same optimization holds for SPLIT SUBPARTITION operations.
发表评论
-
关于Oracle 版本
2015-10-10 10:23 0第一部分是“Version Number",也就是产 ... -
了解Oracle数据库的版本号
2015-10-10 10:20 0Major Database Release ... -
PDF 资料
2013-03-13 15:45 0Java design pattern --Bob ... -
Oracle sys和system用户、sysdba 和sysoper系统权限、sysdba和dba角色的区别 [转]
2013-03-12 14:17 1022sys和system用户区别 1)最重要的区别,存储的数 ... -
Oracle 用户、对象权限、系统权限 [转]
2013-03-12 14:12 0--============================ ... -
表分区分割脚本
2013-03-12 13:10 728表分区分割脚本 -
Oracle Session 视图[转]
2013-03-06 10:17 976v$session v$session_wait v$ ... -
10G中查看历史执行计划信息[转]
2013-03-01 11:02 3761现在总结下10G的,使用的是AWR报告中的信息,主要是查询 ... -
Oracle 表连接 [转]
2013-02-26 15:20 647Oracle 表之间的连接分为三种: 1. 内连接(自然 ... -
oracle的number类型精度、刻度范围 [转]
2013-02-26 15:06 5250一、 oracle 的 number 类型精度、刻度范围 ... -
DBMS_XPLAN.Display_Cursor 分析[转]
2012-12-27 10:49 975Oracle 10 added the awesome pro ... -
Oracle Tablespace
2012-11-29 16:53 01. 几个重要的TableSpace SYSTE ... -
[转]解决ora-01652无法通过128(在temp表空间中)扩展temp段的过程
2012-11-28 11:11 847Tag: http://www.oraclefans. ... -
Estimate TEMP usage without running SQL [转]
2012-11-28 11:09 781Estimate TEMP usage without run ... -
Oracle splitting partitions简单小结[转]
2012-11-27 15:12 995http://www.oracleonlinux.cn/201 ... -
When the explanation doesn't sound quite right
2012-10-30 13:05 0When the explanatio ... -
Bind variables - The key to application performance[转]
2012-11-27 15:16 773Overview If you've been ... -
oracle中join的用法 .
2012-10-10 11:43 0oracle中join的用法8i: create ... -
[转]Oracle中Left Outer Join和外关联(+)的区别
2012-11-27 15:15 837外关联是Oracle数据库的专有语句 Left Outer ... -
[转]关于ORACLE的锁表与解锁总结
2012-09-29 11:11 0总结1:Oracle的锁表与解锁 selects.userna ...
相关推荐
Securing And Optimizing Linux
RedHat - Securing and Optimizing Linux.pdf
作者 Jeff McAhren 在多个行业中有着长达十年的 Essbase 使用经验,包括酒店业、房地产、医疗保健等领域,如 MeriStar/Interstate Hotels and Resorts、Wyndham International、Centex Corp 和 HealthMarkets 等公司...
High Performance Spark Best Practices for Scaling and Optimizing Apache Spark 英文azw3 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除
High Performance Spark Best Practices for Scaling and Optimizing Apache Spark 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除
High Performance Spark: Best Practices for Scaling and Optimizing Apache Spark by Holden Karau English | 25 May 2017 | ASIN: B0725YT69J | 358 Pages | AZW3 | 3.09 MB Apache Spark is amazing when ...
Optimizing Both Cache and Disk PerformanceShimin Chen, Phillip B. Gibbons�, Todd C. Mowry, and Gary Valentin�School of Computer Science �Information Sciences Research Center �DB2 UDB Development ...
"High Performance Spark Best Practices for Scaling and Optimizing Apache Spark" 这一主题深入探讨了如何最大化利用Spark的性能,以及如何进行有效扩展和优化。以下是一些关键的知识点: 1. **资源管理与调度**...
High Performance Spark Best Practices for Scaling and Optimizing Apache Spark 英文无水印pdf pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或...
tunes the aggregation mode and controls how data is split between LTE and WLAN. Results show that the proposed algorithm is able to derive the optimal control parameter settings per cell under ...
Building an Optimizing Compiler Building an Optimizing Compiler Building an Optimizing Compiler
本文将根据提供的课程信息“IBM informix Managing and Optimizing”,深入探讨与IBM Informix Dynamic Server数据库管理和优化相关的关键知识点。 ### IBM Informix Dynamic Server简介 IBM Informix Dynamic ...
This 3rd edition of the very popular title "Securing & Optimizing Linux" looks for security measures that go beyond firewalls and intrusion detection systems to anticipate and protect against upcoming...
### 优化汇编语言子程序 #### 一、引言 在计算机科学领域,汇编语言作为一种低级语言,能够直接与硬件交互,提供了一种高效的方法来编写高性能的代码。本文档旨在介绍如何针对x86平台进行汇编语言编程的优化方法,...
本文《Participation_of_an_Energy_Hub_in_Electricity_and_Heat_Distribution_Markets》深入探讨了能源枢纽在电力和热力分配市场中的参与方式。文章分析了能源枢纽如何通过集成多种能源转换技术,实现对电力和热力...
Mastering Apache Solr 7.x An expert guide to advancing, optimizing, and scaling your enterprise search 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网...