# Database Indexing

The Database Indexing Configuration Editor is used to enable or disable automatic database index creation.

![](/files/EkUK2Ig5irxf19qmCjb2)

| 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.                                                                                                                                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.capstorm.com/reference/configuration-tab/database-indexing.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.