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;

Report message to a moderator

- 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 02 11:53:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.