Saturday, February 22, 2014

Oracle rebuild index

Hi,

Here some reference command that you can re-index you index.

select ' ALTER INDEX ' || INDEX_NAME || ' REBUILD ; COMMIT;' from user_indexes;

run this command, and copy all the output. Paste into SQL script or editor, and run as script.