Re: Set explain output

Posted in 1997

David Williams — Sat, 24 May 1997 19:49:45 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5m4coq$i89@cssun.mathcs.emory.edu>, Denham.M@amstr.com writes >All > >Does anybody know if it is possible to construct a report similar to >that produced by set explain using the sysmaster tables in V7? > Check out the syssqexplain table... Schema will be in $INFORMIXDIR/etc/sysmaster.sql... >I know that some of the information is available there, but not sure >about the info on what indexes and filters etc have been chosen. > >I am trying to automate the process of detecting sequential scans >and determining the processing path. The purpose of this is to avoid >rerunning the query on a production machine. > >Mark > >Denham.M@amstr.com -- David Williams