Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Question Unanswered: keeping tracks of update stats history

    Hi all,
    Does informix keep track somewhere of the last time update stats was ran on an objects and how it was ran - low, med, high, dist?

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: keeping tracks of update stats history

    Originally posted by noober
    Hi all,
    Does informix keep track somewhere of the last time update stats was ran on an objects and how it was ran - low, med, high, dist?

    Hi there,

    First make sure update statistics has been run
    eg. update statistics high for table customer

    select distinct tabname, b.constructed, b.mode
    from systables a, sysdistrib b
    where a.tabid=b.tabid
    order by 1

    The output will be -

    tabname customer
    constructed 12/21/2003
    mode H

    Hope it helps.

    Regards,

    Lloyd

  3. #3
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    and/or can be generated through:
    dbschema -d <database> -hd <tabname>

    Regards,
    Shriyan

Posting Permissions

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