> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/frequently-asked-questions/problems-solutions/how-to-fix-index-and-column-creation-timeouts.md).

# How to Fix Index and Column Creation Timeouts

When CopyStorm adds a new column to an existing database table or indexes a new column the operation may have timeout issues if the table has a large number rows. This article describes how to solve this problem by increasing the amount of time CopyStorm will wait for a DDL operation to complete.

The parameter that controls how long CopyStorm will wait for an ALTER TABLE ADD/ALTER COLUMN, CREATE INDEX, or any other DDL type operation is kept in the [Database Networking](/reference/configuration-tab/database-networking.md) section of the Configuration tab.

The default DDL Timeout Parameter is 3600 seconds so set the value to a much larger value.

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-ca1c51bd3c639917aee04993871247a0d35f4992%2F4fc71f32-Set-DDL-Timeout.png?alt=media)