Hi All,

I have a query that runs for about 10-30min to return results, and was wondering if I add this to a application, how can I determine how long the query has to complete so I can update my progress indicator to the user?

Thanks
Matt
InformixDb (9.52C1)

Hi Matt,


as far as I know, there is no way to determine how long your query will take.
Nevertheless, you can have a good idea of the query plan if you include
"set explain on" before your query. it will write the detailed query plan
in a file called sqexplain.out in the place you run the query from. This is generally a great way to understand whether your query behaves well and a good indicator to how to enhance it.

On version 11.70, the explain file is even more detailed and takes execution time of all the steps of your queries.

But still no prediction on how long it will take