Managing Partitioned Objects Can be a Nightmare

Maclean Liu(刘相兵

Agenda
Partitioning advantages
Partitioning existing objects
Naming conventions
What's new with 10g
Partitioned indexes—a global problem
Tips and Tricks



该文档总结了split partition的一些经验“

Index


invalid indexes and unusable index partitions is the nature of the beast if not local
only way to add to a table that uses maxvalue
keep ahead of yourself allowing no less than 2 empty partitions before last
can avoid invalidating index components
Empty partitions = valid and usable indexes




Splitting affect

If there are rows in the 2 partitions after the split
global index partitions unusable
non-partitioned indexes invalid
local index partitions involved in the split unusable, others still fine
No rows in 1 or both partitions should not invalidate any indexes or index partitions
USER_INDEXES, USER_IND_PARTITIONS, USER_IND_SUBPARTITIONS



Managing Partitioned Objects Can be a Nightmare.ppt (663 KB, 下载次数: 5, 售价: 5 金钱)

2012-1-31 22:24 上传

点击文件名下载附件
售价: 5 金钱  [记录]

zhuqibs

分区的事情，很有了解的必要！

aiirii

开始在项目中大量应用分区，下载学习一些可能出现的负面效果