Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Unanswered: Performance tuning in Informix

    Hi

    I have a query which selects data from two views, view1 view2.

    first time when i execute the query, it returns the result in fraction of seconds.

    However, when I run the query again, 2nd time onwards, the performance is very slow and it takes around 10 secs to get the result...

    I tried creating indexes on the tables from which the views are fetching data, but it was of no use..

    Kindly suggest me some solution


    Thanks and Regards

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    ________________________________________
    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).
    ________________________________________

  3. #3
    Join Date
    Jun 2005
    Location
    Santa Fe, Argentina
    Posts
    27
    Yes, set de sqexplain and send us them. you must write a sql code like
    " database xx; set explain on; your queries; set explain off".

    You must find a file named "sqexplain.out" with de "optimizer path". These file may help to find (and solve) the problem. bye.

Posting Permissions

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