Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Optimization of all indexes?

755744Apr 1 2010 — edited Apr 1 2010
Hello,

I know that an "alter index X coalesce" optimizes the index X. But I want to optimize all indexes of a database but I don't want to write a script with some hundred alter index statements? Is there a smart way to do this like:

for i in indexes loop
alter index i coalesce;
commit;
end loop;

(Pseudocode)

Edited by: user9206958 on 01.04.2010 01:30

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2010
Added on Apr 1 2010
6 comments
493 views