Re: How to trace a SQL statement
Hello,
try SET EXPLAIN ON from dbaccess before the sql statement you want to
trace.
After this sql statment SET EXPLAIN OFF.
You will find information about the performance of your sql in
sqlexplain.out
Hope this helps.
Regards
Alexander
SoftTeam Blas Catherine <catherine.blas@soft-sol.com> '''''''' ' ''''''
<72s5m4$j0n$1@news.xmission.com>...
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_00A9_01BE1247.14B9EE20
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 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
>
> ------=_NextPart_000_00A9_01BE1247.14B9EE20
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> <HTML>
> <HEAD>
>
> <META content=3Dtext/html;charset=3Diso-8859-1 =
> http-equiv=3DContent-Type>
> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT color=3D#000000 size=3D2>Hello,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT color=3D#000000 size=3D2>I've been working with an Informix =
> Database with=20
> ASP for a little time now.</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2>We are running Windows/95 and WinNT =
> for clients=20
> and servers.</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
> <DIV><FONT color=3D#000000 size=3D2>My question is to know how I can do =
> to have a=20
> trace of my SQL request; In fact, I want to know if Informix uses =
> correctly=20
> indexes that I create, how much time it is in a table (during the =
> request),=20
> ...</FONT></DIV>
> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
> <DIV><FONT color=3D#000000 size=3D2>Thanks in =
> advance</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_00A9_01BE1247.14B9EE20--
>
>