Fragmentation when creating non-clustered index
0
votes
1
answer
106
views
When I was dealing with fragmentation, I had a question about a non-clustered index. In non-clustered index actual table data (typically stored in a clustered index, otherwise a heap) is stored separately from the non-clustered index.
How does this impact table and index fragmentation when I create non-clustered index?
I appreciate a detailed response.
Asked by volodya_neftyannik
(35 rep)
Jan 20, 2024, 12:45 PM
Last activity: Jan 20, 2024, 02:34 PM
Last activity: Jan 20, 2024, 02:34 PM