Results 1 to 5 of 5

Thread: Statistic ...

  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: Statistic ...

    Hello..

    Are there one view to check if one table is updated with statistics and what statistic was executed on it ?


    Att,
    Fernando.

  2. #2
    Join Date
    Dec 2006
    Location
    Latrobe, PA
    Posts
    16
    select distinct tabname, b.constructed, b.mode
    from systables a, sysdistrib b
    where a.tabid = b.tabid
    order by tabname

  3. #3
    Join Date
    Oct 2007
    Posts
    61

    Hi

    I run it.. and see two statistics in my database.

    I no see low mode...

    My statistic's ok ?


    tabname constructed mode

    estoque_trans 2008-01-16 H
    estoque_trans 2008-01-16 M

    2 Row(s) affected

  4. #4
    Join Date
    Dec 2006
    Location
    Latrobe, PA
    Posts
    16
    Informix does not report low mode statistics. Low mode is more like updating the system with the row counts of the tables.

    Your statistics are perfect.....!!!!

  5. #5
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    IDS 11.10 - systables:ustlowts
    Before IDS 11.10 - don't have
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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