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.