Re: explain plan without actually executing the SQL

Posted in 1999

Mike Aubury — Sun, 28 Feb 1999 20:42:36 -0000 — source: Informix-list mailing list archive (1991-1998)

I've done this with using prepare let lv_str="select * from systables" prepare p1 from lv_str ... Theres a field on sqlca which gives the cost.. 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