Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: UPDATE STATISTICS and system tables

    does UPDATE STATISTICS modify any other
    system tables except sysstatistics ?

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: UPDATE STATISTICS and system tables

    does UPDATE STATISTICS modify any other
    system tables except sysstatistics ?
    Yes, systabstats

  3. #3
    Join Date
    Jun 2003
    Posts
    140
    thx for reply, can u pl. specify what does
    get updated in systabstats ?

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

  5. #5
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    There is a subtle difference between these 2 system tables;

    systabstats stores information about the table or index as an object. For Eg: the size, number of rows, and so forth.

    It gets updated by query processing, data definition language, and update statistics commands.

    Whereas sysstatistics stores information about the values in a specific column. It is updated by data definition language and update statistics commands.

Posting Permissions

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