PREVIOUS | NEXT
Workflow supports indexing to improve the response time of queries on custom tables with large amounts of data, or when multiple tables are joined together in a query. You can create indexes for tables in the Custom Tables workspace on columns that you often use in SQL queries.
Indexing can enforce a unique constraint on the column, ensuring duplicate data cannot be added or updated in the column. We display an error message when a user or script attempts to add a duplicate value to a column marked unique. When you create a unique constraint on a column with duplicate values, we also display an error.
We impose the following constraints for indexing:
To access the Custom Tables workspace, go to Setup > Development > Custom Tables.
[Back to top]
To add a new Index to an existing custom table:
Workflow adds the new index to the list of existing indexes, if any. We display these details on the list:
You can delete an index by clicking Delete Index on the available actions menu. You cannot edit an existing index.