Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

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

Post Details

Locked on Apr 29 2010
Added on Apr 1 2010
#general-database-discussions, #index
6 comments
489 views