Hi,


Is there any way to get QEP (Query Execution Plan) of a standard baan session. We are on Informix. There are ways to get QEP for Oracle by setting trace on for a Oracle session id, but I am not sure how we can get the same for Informix.

Thanks in advance

Hi,

did you try to set TT_SQ_TRACE on before you run the query ?

-- -set TT_SQL_TRACE=040 -logfile /tmp/qep.txt -keeplog

This should give a good idea of what Tables are accessed by the query. By setting different values for TT_SQL_TRACE you can also get .e.g. the execution times for each staement. Possible values for TT_SQL_TRACE can be found in the Baan Driver Documentation.

Hope this helps.

Mario

There are also INFSTAT and INFPROF, working basically the same as ORASTAT and ORAPROF.