online index rebuild Problem

Hi

Please advice whether i have to do update stats after i do online index rebuild

I use Alter index with (options as below)

ONLINE = ON

SORT_IN_TEMPDB = ON

STATISTICS_NORECOMPUTE =OFF

Should i be doing update stats after this online index rebuild?

After doing online index rebuild when clients connecting to DB the Response time has increased ..

During Online INDEX REBUILD page file usage rises from 3 Gb to 10 GB and stays at 10 Gb even after online index rebuild

i have no idea on this ..

pls Advice ...I Need help..........................

Thanks in advance

By rebuilding the index, the default behavior of SQL Server 2005 is to autoupdate statistics

So no extra work is needed by you

|||

Pagefile is increased, then check the memory settings on SQL Server.

Also if there are tables with frequent inserts and updates then its better to schedule an intermittent UPDATE stats for optimum performance.

online index rebuild and update statistics

Hi ..

Please advice whether i have to do update statistics along with Index rebuild (online /off line)

Thanks in advance

This depends on the traffic on your DB. IF its an OLTP/heavily used DB you might keep this for off peak use. Your Index scripts could be scripted to either update or do not update stats. You dont *have to* update stats. Its optional. But generally its good to keep updated stats. Again, depending on your Db size and usage, you can turn Auto Statistics ON or OFF.|||

Manual statistics update is preferable in off-peak hours

|||To reword his question a little bit, if you perform Alter Index .... Rebuild, do you need to also perform an Update Statistics with full scan afterwards? The Alter Index ... Rebuild updates stats based on sampling rates. Is there any real advantage to updating the stats with a full scan afterwards?

online index rebuild and update statistics

Hi ..

Please advice whether i have to do update statistics along with Index rebuild (online /off line)

Thanks in advance

This depends on the traffic on your DB. IF its an OLTP/heavily used DB you might keep this for off peak use. Your Index scripts could be scripted to either update or do not update stats. You dont *have to* update stats. Its optional. But generally its good to keep updated stats. Again, depending on your Db size and usage, you can turn Auto Statistics ON or OFF.|||

Manual statistics update is preferable in off-peak hours

|||To reword his question a little bit, if you perform Alter Index .... Rebuild, do you need to also perform an Update Statistics with full scan afterwards? The Alter Index ... Rebuild updates stats based on sampling rates. Is there any real advantage to updating the stats with a full scan afterwards?