Create a table index

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.

Before you begin

Role required: admin

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. 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.
  6. To create a unique index, check the Unique Index box.
  7. Click Create Index.
    The Table Name field is there for your reference only. Overriding the default has no effect.