Optimization of all indexes?
755744Apr 1 2010 — edited Apr 1 2010Hello,
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