All Forums UDA
marcmc 112 posts Joined 12/05
30 Sep 2008
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?

10 Mar 2009

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?

Ramakrishna Vedantam, Tata consultancy services, Hyderabad

You must sign in to leave a comment.