The Web Databases feature allows you create indexes on one or more fields in your table. This allows the database to more quickly retrieve search results for very large datasets, and also allows administrators to define a unique constraint on the index, which ensures duplicate entries are not allowed. This articles describes how to set up both of these options. This feature is only available to Level 1 administrators or Web Database application administrators.
Creating an Index
To create an index, go to the Designer section of the databases, then go to the Tables section. Next, click the Table, and choose Options. There, you will find a Design tab. Next to each field in the Design tab, there is a checkbox for Index.
Click the checkbox for Index next to the field that you want to index. For example, if you want to index FirstName, LastName, and Company, check next to FirstName.
The index editor will pop up. To add additional fields to the index, click Add.
You can also re-order the fields by moving them up and down. This creates priority in the index for faster lookup. Once done, click Save.
Making an Index Unique
To make an index unique, go to the Designer section of the databases, then go to the Tables section. Next, click the Table where the index is located, and choose Options. There, you will find a Design tab. There, you will see the index checked, and to the right will be the details of the index.
Click the checkbox for Index that you want to make unique. The index editor will pop up. At the bottom, check the checkbox labelled "Make this index Unique", then click Save.
*Note that the system will validate for the fields chosen. For example, if the unique index contains FirstName and LastName, a user can enter "John" for as many records as they would like, but there can only be one "John Smith", as the uniqueness is validated on the combination of FirstName and LastName.