Set explain output

Posted in 1997

Denham.M@amstr.com — 23 May 1997 11:23:06 -0400 — source: Informix-list mailing list archive (1991-1998)

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? 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