Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    10

    Smile Unanswered: last update statistics time/date

    Can anyone tell me how to tell when the last time update statistics was run for a table (or all tables)? I was surprized that this wasnt in the online.log, but I am new to informix. thx
    Karma...it works regarless of your belief in it.

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

    Re: last update statistics time/date

    Originally posted by GoldenBoy
    Can anyone tell me how to tell when the last time update statistics was run for a table (or all tables)? I was surprized that this wasnt in the online.log, but I am new to informix. thx
    Hi there,

    Try the below statement

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

    Regards,

    lloyd

Posting Permissions

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