Converting Descending Indexes

As of PeopleTools release 8.54, to optimize performance, descending indexes are no longer supported. If you are upgrading from an earlier version of PeopleTools, you must convert any descending indexes to ascending indexes by dropping descending indexes and recreating them as ascending indexes.

The following scripts are provided in <PS_HOME>\SCRIPTS\ORA\ to accomplish this task:

  • postupgcreatedescindexes.sql

  • postupgdropdescindexes.sql

To convert descending indexes to ascending indexes, complete these steps:

  1. Connect as AccessId, run postupgdropdescindexes.sql

  2. Connect as AccessId, run postupgcreatedescindexes.sql

  3. Connect as AccessId, run psdropdescindexes.sql

  4. Connect as SYSDBA and run alter system set "_ignore_desc_in_index"=true;

  5. Connect as AccessId, run pscreatedescindexes.sql

  6. Connect as SYSDBA and run alter system set "_ignore_desc_in_index"=false;