RE: Change in Statistics

• Previous message: Steve Kass: "Re: IN Clause - Stuck on an easy query :-("
• Messages sorted by: [ date ] [ thread ]

Date: Wed, 01 Sep 2004 20:31:00 GMT

I believe that the Index Tuning Wizard will provide you scripts for the
recommended index(s) or stats that it may see beneficial. However unless
you specifically instruct the wizard to create the index(s) and/or stats it
will not create them. Typically implementing the recommendations that you
get, should provide you benefit for any queries that are "similar" to the
one that you used to get the index recommendations in the first place.

SQL Server is complex product and the area of performance tuning is a not a
simple one. If you are interested in learning Performance Tuning, please
read the following articles :

243589 HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=243589

324692 Support WebCast: How to Collect and Analyze Performance Data in
http://support.microsoft.com/?id=324692

322866 INF: RDBMS performance tuning guide for data warehousing (white
paper)
http://support.microsoft.com/?id=322866

325024 Support WebCast: Effective Indexing and Statistics with SQL 2000
http://support.microsoft.com/?id=325024

814324 Support WebCast: Microsoft SQL Server 7.0 and SQL Server 2000 Indexes
http://support.microsoft.com/?id=814324

311826 INF: Index Tuning Wizard Best Practices
http://support.microsoft.com/?id=311826

815337 Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans
in
http://support.microsoft.com/?id=815337

This is probably way more information than you wanted, but if you are
interested, the above articles make interesting reading. All the best.

Thank you for using Microsoft newsgroups.

Sincerely

Pankaj Agarwal
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

• Previous message: Steve Kass: "Re: IN Clause - Stuck on an easy query :-("
• Messages sorted by: [ date ] [ thread ]