Re: SET EXPLAIN

Posted in 1996

Barry Leb — 31 Jul 1996 09:03:26 -0400 — source: Informix-list mailing list archive (1991-1998)

At 05:17 AM 7/29/96 GMT, you wrote: >Hi >Is there any way of using set explain but not execute the sql >statement. >ORACLE has the explain plan sql statement which only produces the >execution plan(into a table) of the supplied sql statement. > >Informix 7.1.3 UC1 Several people have responded to this and mentioned using INTERUPT. In fact, I use this method myself. However, there is another way, unfortunately, I don't remember it. It was given to me by an Informix instructor out of Chicago. His name is Dan Geoppo. If anyone can get this from him and post I'd be interested myself. Barry Leb National Linen Service 1420 Peachtree Street MS #230 Atlanta, GA 30309 e-mail: barryleb@mindspring.com