Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Unanswered: Informix Update Statistics

    Good day Everyone,

    I am seeking assistance in understanding how statistics are stored and updated in Informix. From one of the manuals I read, I saw that the SYSDISTRIB, SYSTABLES, SYSCOLUMNS and SYSINDEXES are the tables that are updated, however the data residing in these tables do not make much sense to me....

    What I would really like to find out is where information for when the last update statistics statement was run for given tables. Using Sybase I can obtain this information using the 'Optdiag <tablename>' command... is there an Informix equivalent?


    Barry Cochrane

  2. #2
    Join Date
    Dec 2004
    Posts
    2

    Informix Update Statistics - Solution Found

    Good day again,

    I was able to obtain a solution to my earlier post... (browsing through previous messages in this forum )


    For those interested:-


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

    Apologies, if I wasted anyone's time...


    Regards,

    Barry Cochrane

Posting Permissions

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