Sample Header Ad - 728x90

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