Home > Archive > MS SQL Server > July 2005 > Index Tuning Wizard and CREATE STATISTICS









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Index Tuning Wizard and CREATE STATISTICS
JJ

2005-07-15, 11:23 am

I ran the Index Tuning Wizard on a workload file from the SQL Profiler and
it came back with some recommendations.

In the script it generated, it had statements to create indexes, but it also
had some CREATE STATISTICS statements in there with the same columns as it
placed in the index it generated.

We run sp_updatestats on a weekly basis. Are these CREATE STATISTICS statements
necessary? Won't the statistics get created when the index is created or
sp_updatestats is run?


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com