Answer
Fragmentation occurs when index pages become disordered, slowing scans and seeks.
Fill factor controls how much free space to leave during index creation to reduce fragmentation.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ