1 Reply Latest reply: Nov 19, 2012 9:06 AM by HakanBiroglu RSS

    Saving Indexes

    user10480127
      Hi All,

      We have some indexes which we place on some PS tables, but whenever a major bundle or tools release impacts a table the index we've placed via the DB gets wiped out and there is no easy way to track this. The question has come up, is there a way to save an index as a PeopleSoft object (preferabby not an SQL object, but something in relation to the table/field in which the index is placed so that when we run our change report we can see the object come up as impacted). If this is not possible are there other ways/recommendations you can share from experience regarding how to best track db changes made (e.g indexes).

      Thanks so much for any input.
        • 1. Re: Saving Indexes
          HakanBiroglu
          You should create custom indexes via Application Designer menu Tools - Data Administration - Indexes. These will become PeopleSoft Managed Objects.

          See also PeopleBooks
          PeopleBooks > PeopleTools 8.52: PeopleSoft Application Designer Developer's Guide > Administering Data > Creating Indexes
          http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tapd/book.htm?File=tapd/htm/tapd10.htm#H4037

          Edited by: Hakan Biroglu on Nov 19, 2012 4:06 PM