Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Create a table index

Log in to subscribe to topics and get notified when content changes.

Create a table index

Constructing an effective index requires specialized knowledge in database architecture. If you do not have this expertise, you should consult someone who does.

Before you begin

Role required: admin


  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 slushbucket 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, you should 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.