Re: Explain Plan for queries

Posted in 2003

Fan Ruo Xin — Sat, 25 Oct 2003 15:31:31 GMT — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: > > 2. As I mentioned I need to obtain query plans for multiple > > queries. Is there a way to run a whole file having all these > > queries using DBACCESS? > > Yes. Edit a file to contain: > > SET EXPLAIN ON;> SELECT ...; > SELECT ...; > SELECT ...; > Is there a way I can capture the access plans for all the sql stmts written in a java (JDBC) application?