Re: How to trace a SQL statement

You can trace your SQL statements by issuing SET EXPLAIN ON statement before executing the SQL statement. This makes informix to write optimization messages to $INFROMIXDIR/sqexpln directory. But you need to find another way to keep track of the time passed by during the query execution. There is no time stamp for optimization messages. PS: these are all for Informix DS 7.23. Informix has added some more information about optimization for version 7.3. Gursoy YERLI > SoftTeam Blas Catherine wrote: > > Hello, > > I've been working with an Informix Database with ASP for a little time > now. > We are running Windows/95 and WinNT for clients and servers. > > My question is to know how I can do to have a trace of my SQL request; > In fact, I want to know if Informix uses correctly indexes that I > create, how much time it is in a table (during the request), ... > > Thanks in advance