Originally posted by Eddy99

Out of interest does anyone have any real time experience of what kind of impact rebuilding the indexes online has on system performance ?
If you rebuild one index, performance will not suffer that much but you better rebuild them at hight when there is no DB activity. Do you drop and rebuild, or just rebuild?

I just rebuilt 5 indexes in a small production detabase (by dropping them first), nobody complained (it took me 2-3 minutes or so).