Re: explain plan without actually executing the SQL

Posted in 1999

Bob Colombo — Tue, 2 Mar 1999 05:29:40 -0500 — source: Informix-list mailing list archive (1991-1998)

I believe the explain plan will be generated upon preparing the statement (e.g.in ESLQ). Regards, bc Jay Walters wrote in message <36D99F9D.2516C1F1@computer.org>... >Is there a way to get the query plan for a query without executing the >query? I can only find set explain on and then running the query which >can be a bit of a pain if the query isn't too good to start with. > >Cheers