Create Indexes Before Dropping Tables in Alter Table UDFs
Open
performance
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
The `postLoadCommands` in the `ConvertTable` function can take a long time for large tables because indexes are created there. Moving them to before dropping the old table could prevent blocking reads.
The problem is before dropping the old table the old indexes will still be there, so there might need to be some renaming for the indexes.
Contributor guide
Assessment
This issue has not been assessed yet.