Post reply

Statistics in SQL 2000

  • November 9, 2004 at 10:53 am

    #109509

    when I ran Display Execution Plan one of my tables was in red and it said that some of the Statistics are missing.  Why does it happen? is it ok for me to Create Missing Statistics which SQL suggests.

    Please explain to me the pros and cons of managing statistics.

    thanks

     

  • November 10, 2004 at 12:00 am

    #529556

    Hi Minu,

    I'd do as SQL server suggests and recreate those statistics. The same has happened to me in the past

    and I don't think anything bad will happen to you (fingers crossed

     

    As I understand it SQL server maintains these statistics to assist its query analyser in making decisions regards

    query optimisation (ie rewriting my silly queries so they work nice and quick .

     

    Hope that helps,

     

    Ben.

  • November 10, 2004 at 1:35 am

    #529566

    True, statistics are used by SQL Server's query plan optimiser. 

    Perhaps you turned off 'auto create statistics' or 'auto update statistics' on your database. Make sure both of these are on, and SQL Server will automatically look after the necessary statistics for you!

    Julian Kuiters
    juliankuiters.id.au

  • November 10, 2004 at 7:53 am

    #529618

    Thanks for the reply.  I did add those statistics. 

  • November 10, 2004 at 10:01 am

    #529650

    its better to run the Statistics manuly once in a week

    Beacuse its harm the perfomance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply