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.
