How to trace a SQL statement
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--