Database Indexes

• Indexes speed up reading from a database at a small disadvantage of slowing down writing operations
• Design your index together with your tables, prior to having a performance issue
• In some cases, a bad index can be worse than no index at all on the table

Creating Indexes

1. Navigate to System Definition > Tables.
2. Open the table you want to create a database index for.
3. In Database Indexes Related List, click New.
4. In the Index Name field, add a value for the index.

5. Using the slush bucket, select the fields to be included in the index.

   The order in which the fields are selected affects how the database index works.

6. To create a unique index, set the Unique Index field to true.

7. When done, click Create Index.

Improved transaction time

• Data structure to optimize queries on a database table for improved transaction time.
• Remember to always test your indexes in a Sub-production instance to ensure performance improvement before synching to Production.

By admins

• NOTE: Constructing database indexes is an advanced procedure which should be performed by administrators who have specialized knowledge in database architecture and management.