Home » RDBMS Server » Performance Tuning » partitioned table indexes, rebuild
partitioned table indexes, rebuild [message #167117] Tue, 11 April 2006 07:45 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
whats the difference ??

alter table bigtable
modify partition p1_col1 rebuild unusable local indexes;

"and"

alter index idx_bigtable rebuild partition i_col1;
Re: partitioned table indexes, rebuild [message #167216 is a reply to message #167117] Tue, 11 April 2006 21:43 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The first one rebuilds all local indexes in the partition that are unusable.

The second one rebuilds just the one partition of the one index, regardless of whether it is locally partitioned or globally partitioned, regardless of whether it is unusable or not.

Ross Leishman
Previous Topic: db_block_buffers = 0
Next Topic: Use of Histogram and Statistics for All Index columns or All columns?
Goto Forum:
  


Current Time: Sun May 26 22:37:05 CDT 2024