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

Use SET EXPLAIN to debug:
IBM Informix Dynamic Server v11.50 Information Center

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.