How to improve Catalog searches?

Catalog searches from OIM identity console may get slower over time. The catalog searches can be improved by rebuilding Oracle indexes on the CATALOG table.

1. Run this query to find all the index on the table select * from user_indexes where table_name='CATALOG';
   
2. The query will produce result like this
   CATALOG_PK
   UK_ENTITY_KEY_TYPE
   IDX_CATALOG_IS_DEL
   IDX_CATALOG_IS_REQ
   IDX_CATALOG_ENTITY_KEY
   CAT_TAGS
   IDX_CATALOG_ENTITY_TYPE
   
3. Run this command to build each indexes  ALTER INDEX <index_name> rebuild;