Re: Rebuild indexes

Yes, you have to do this for every index you want to rebuild. Consider, that you will have a downtime for the table on which the index is. (The Rebuild places an exclusive table lock on that table.) And you need enough spaces in your temp dbspace. So, to find out how much time and temp space you need, you should test the index rebuild on your test system, which should match as much as possible (data volume etc.) the production system. To get the statistics of a table, i use: UPDATE STATISTICS MEDIUM FOR TABLE table_name;