Table and Index rebuild
来源:互联网 发布:航空托运算法流程图 编辑:程序博客网 时间:2024/05/02 12:47
Table rebuild
1: CATS
ORDER BY (best solution)
create table new_customer parallel (drgree 11) as select * from customer oder by customer_number
INDEX TIPS
create table new_customer as select /*+ index(customer customer_primary_key_idx)*/
* from customer oder by customer_number
[TIP] benefit for SELECT statement include clause like where 'B%'
2: EXP/IMP
3: SQLLOAD
Index rebuild
ALTER index index_name rebuild [online] ;
when need rebuild index ?
1: above 5 I/O operations duing one truncation
2: blevel >4
3: del_bleaf > 20% bleaf
oracleHu 2005-10-28
- Table and Index rebuild
- alter index rebbuild and rebuild online
- What the difference between rebuild index and re-organize index?
- rebuild index
- index rebuild
- rebuild index
- Table and Index Movement
- rebuild index VS. rebuild index online
- alter index rebuild & alter index rebuild online
- alter index rebuild & alter index rebuild online
- rebuild index 的机制
- When Rebuild INDEX?
- rebuild oracle index
- rebuild index 相关
- rebuild index方式
- oracle index rebuild online
- index rebuild和rebuild online的区别
- alter index rebuild 与 rebuild online
- rpm常用命令及rpm中文手册
- patching oracle erp 11i
- oracle erp locks info
- oracle advance security option
- Discuz论坛2.5 升级到PHP MySQL新版遇到的问题
- Table and Index rebuild
- J2ME加密数据的一个第三方开源免费类库介绍
- Tuning SQL note1
- 开始linx咯
- NEC API
- sizeof以及乱七八糟的指针
- Xplain and Outline
- 它们在干什么?Google猫和老鼠的故事
- This New Year's Day of 2006 will Delay by a Second