Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Create a table index

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


  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.

This site is scheduled for a small content update on Wednesday, December 12th, between the hours of 4:00pm and 8:00pm Pacific Time (Dec 13 00:00 – Dec 13 4:00 UTC). Access to this site may be slightly delayed during that time.