Re: SET EXPLAIN output file for OWS 7.22 on NT?

Posted in 1998

Joe Lumbley — Tue, 12 May 1998 04:23:53 GMT — source: Informix-list mailing list archive (1991-1998)

Fuzzy (granta@nospam.student.canberra.edu.au) wrote: : Hi people, : I'm trying to use the SET EXPLAIN option to work on some queries on my : WinNT OWS 7.22 server. I can't find any reference to where the query : plan is place. No evidence of an sqexplain.out file, or anything like : that. : Anyone have any idea what to look for or where this is placed on NT? Not sure about OWS, but ODS for NT puts in the $INFORMIXDIR/sqexplain directory as filename yourusername.out : Ciao : Fuzzy : :-) -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998 from Prentice Hall/Informix Press. ---------------------------------------------------------------------------