Create a table index

Create a custom index for a table.

Before you begin

Role required: admin

Constructing an effective index requires specialized knowledge in database architecture. We recommend that if you do not have this expertise, you consult someone who does.

Note: In this release, custom indexes are not tracked in update sets.

Procedure

  1. Navigate to System Definition > Tables.
  2. In the list, find the table you want and click its label.
  3. Navigate to the Database Indexes related list.
  4. Click New.
  5. In the Index Name field, type a name for your index.
  6. Use the slush bucket to select the fields you want included in the index.
    The order in which you select the fields affects how the index works. If you do not have expertise in database design, we suggest you consult someone who does.
  7. To create a unique index, check the Unique Index box.
  8. Click Create Index.
    The Table Name field is there for your reference only. Overriding the default has no effect.