Find our query that takes long time

Posted in 2007

mohitanchlia@gmail.com — Sun, 16 Sep 2007 05:28:15 -0000 — source: Usenet: comp.databases.informix

Version: IDS 10 I just have a small question: Does informix stores the query execution time, user who executed it etc. somewhere or something that gives some Warnings about queries that are really bad. I was thinking if there is any easy way to find out about query statistics without having to put set explain on and some kind of debugging around the queries. It wouldhelp a lot where there are thousands of queries in a complex application. I am sure what I am asking for is not relevant for informix to store because onus lies on the application developer, still I thought I'll ask.