Managed tables design: Indexes

Index is a powerful tool that can be used to speed up retrieval of rows from the table. SolveXia allows to create non-clustered index on your managed tables for your query optimizations.

How to set up an index on your managed table

1. Open the managed table.

2. Click Add index.

3. Select columns that will form a clustered index on your table.

• Note that the order of columns in the index matters.

4. Click Save.

• Columns in the managed table structure will have icon identifying that they are a part of an index.
• Note that you cannot change (edit name, type or delete) columns that form an index.

How to change the index on a managed table

1. Open the managed table.

2. Click on the index to change it.

3. Change columns that should form your new index.

4. Hit Apply.

5. Click Save.

How to delete the index from managed table

1. Open the managed table.

2. Click on the index.

3. Click Delete index.

4. Click Save.