Re: SET EXPLAIN
Paul van Wegen Esq. 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
In dbaccess just press INTERRUPT. The plan should be output to the file sqexplain.out
after only a second or two.
Cheers,
--
Mark.
+-------------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| |
|mailto:marks@west.co.za +------------------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work... force it! |
|Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! |
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+------------------------------------------------+