Score:1

Index rebuild of system-versioned table

us flag

Curious, if a table is system-versioned and an index needs to be reorganized/rebuilt, how will its history table affect this operation. Does the history table have to get checked/scanned during an index rebuild on the main table?

Ben Thul avatar
cn flag
I would speculate that from an index maintenance standpoint, the history table is managed separately since IIRC it can be indexed in a completely different way than the parent table. As such, there isn't necessarily an analogous index to maintain. That said, I'd just try it (in a test environment if you're concerned) and see what happens.
Score:1
in flag

When you do index maintenance on an index in SQL Server, the history table of a system-versioned table will not be affected by this operation. The history table is a separate and independent table. The history table will not be scanned at all.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.