I have a request to run Statistics on a DB/Schema.
This will improve response time and query performance for a clients
data.
I have never done this. New to SQL Server.

Can some please provide me some ideas what needs to be done. Also,
how does the statistics improve performance?

Thanks

rogv (rvaedex23 (AT) gmail (DOT) com) writes:
The simplest is to say sp_updatestats and your done. However, this only
samples the table. Running UPDATE STATISTICS WITH FULLSCAN on all tables
will give more complete statistics. It will on the other hand, take far
longer time.

The optimizer uses the statistics to estiamate the cost for different
query plans. More accurate statistics gives better odds for a better plan.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

In addition to Erland's advice, you may want to read this Books Online
topic: http://msdn.microsoft.com/en-us/library/ms190397.aspx. While written
for SQL Server 2008, it is applicable to previous versions of SQL Server as
well.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of SQL Server 2005 Books Online from
http://technet.microsoft.com/en-us/s.../bb428874.aspx
Download the latest version of SQL Server 2008 Books Online from
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx

"rogv" <rvaedex23 (AT) gmail (DOT) com> wrote

I replied to this in another group. Please don't multipost.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"rogv" <rvaedex23 (AT) gmail (DOT) com> wrote

On Mar 17, 3:47*am, "Tibor Karaszi"
<tibor_please.no.email_kara... (AT) hotmail (DOT) nomail.com> wrote:
Thanks for the info.