| partitioned table indexes, rebuild [message #167117] |
Tue, 11 April 2006 07:45  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
