Dropping table indices - Data Pages

UDA
Enthusiast

Dropping table indices - Data Pages

I was wondering if I drop indices on a table(100million rows) without dropping & rebuilding the table will it leave large white spaces on the data pages that could impact performance negatively?
1 REPLY
Enthusiast

Re: Dropping table indices - Data Pages

PI cannot be dropped anyway. There are optimized work arounds to drop a SI. Which indices are you discussing here? The filesystem and the automatic defragmentation takes care of the white spaces. So where is the worry?