Table and Index rebuild

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