Database Indexing
The Database Indexing Configuration Editor is used to enable or disable automatic database index creation.
| Parameter Name | Default Setting | Required | Description |
|---|---|---|---|
| Create Indexes | Checked | No | If checked, CopyStorm will create database indexes for each reference field. Enabling index creation will significantly improve the table join speed in larger databases.
Note that an index is always created on each table’s “timestamp” column. |
| Create Indexes Early | Checked | No | If checked then CopyStorm will create indexes on Salesforce reference fields when a table is initially created. If not checked then reference field indexes will be created after the first backup of a table. This option can avoid a long delay or timeout when indexes are originally created on tables with many rows. |
| Create IsDeleted Index | Checked | No | If checked then CopyStorm will create an index on the fields (IsDeleted, SystemModstamp). |
| Rebuild Timestamp Index | Unchecked | No | If checked, the index on the SystemModstamp column will be rebuild if enough new records are inserted. In some database configurations, this can increase performance dramatically. |