2 Replies Latest reply: Jul 15, 2013 5:22 AM by HakanBiroglu RSS

    Index naming in PeopleSoft

    user10274093

      Hi,

      on FSCM 91, on Win 2008, Tools 8.52, DB Oracle 11g.

      is there any rule to name des indexes (in Oracle DB)for PeopleSoft ? What is it ?

      Thanks.

        • 1. Re: Index namin in PeopleSoft
          HakanBiroglu

          PeopleBooks > PeopleTools 8.52: PeopleSoft Application Designer Developer's Guide > Administering Data > Creating Indexes

           

          Indexes enhance system performance by generating key lists that the application processor uses to extract the data that it uses to populate pages and search records. The system automatically creates:

          • Standard indexes (key or duplicate order key indexes) if at least one field in the table is a key or duplicate order key.The index contains all key and duplicate order key fields. The system automatically names this index with a prefix of PS_.
          • Alternate search key indexes for each alternate search key.The system automatically names this index with a prefix of PSn, in which n is a number between 0 and 9.
          • Custom indexes, which you can define using the Edit Index, Edit DLL, and Add Index dialog box in the PeopleSoft Application Designer administration tools.The system automatically names this index with a prefix of Psa, in which a can be any letter between A and V. The system does not create custom indexes automatically.
          • 2. Re: Index namin in PeopleSoft
            user10274093

            thank you.