Re: Explain w/o execution

Posted in 1998

Art S. Kagel — Wed, 18 Feb 1998 09:43:15 -0500 — source: Informix-list mailing list archive (1991-1998)

Lauri Pietarinen wrote: > > Is it possible to get the explanation of an access path without > executing the query? > > Now the steps to be taken are... > > 1. execute "set explain on" > 2. execute the query > > When operating against a big database, it would be nice to know in > advance > if the access path will be reasonable. You can begin execution then interrupt the query after a few seconds the SET EXPLAIN output is written before the query is actually executed. You do not need to wait for the query to complete. Art S. Kagel