System versioned temporal tables in MSSQL - index maintenance script #1049
|
Dear, |
Answered by
olahallengren
Jun 24, 2026
Replies: 1 comment 1 reply
|
Temporal tables are handled in the script the same way as any other tables — both the current and the history table. Rebuild and reorganize work fine while system versioning is on, so you don't need to do anything special. I have tested it and it works well. |
1 reply
Answer selected by
braest
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Temporal tables are handled in the script the same way as any other tables — both the current and the history table. Rebuild and reorganize work fine while system versioning is on, so you don't need to do anything special. I have tested it and it works well.