Re: SET EXPLAIN

Paul van Wegen Esq. (vanwegen@firststate.com.au) 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. Sybase and SQLSERVER let you do the same thing. For Informix, You can run dbaccess or isql with the "set explain on" at the beginning. As soon as it flashes "explain" <....whatever it says> at the bottom of the screen, you can hit a control-c and abort it if you don't want the sql to execute (assuming it will take long enough to run that you can catch it in time). Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------