Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    42

    Question Unanswered: Update Statistics

    Hello all,

    Quick question. In Oracle, to gain performance on big tables, I use the command ;

    ANALYZE TABLE table_name COMPUTE STATISTICS;

    Is there the same thing in SQL Server 2000?

    Thanks a lot !

    Regards,

    Svrider

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    SQL Server 2000 automatically updates statistics on its tables.

    If you want to run them by hand, try running UPDATE STATISTICS table_name
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •