Re: Show query plan?

Posted in 2000

Sujit.Pal@bankofamerica.com — Thu, 06 Jan 2000 10:01:26 -0800 — source: Informix-list mailing list archive (1991-1998)

Sunil SET EXPLAIN ON;before the query will dump the query into a file sqexplain.out in the current directory. HTH Sujit Sunil Bhaskarla <sunil@intelus.com> on 01/06/2000 05:49:46 AM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Show query plan? How can I see what the query engine is doing behind the scenes when I type a query? In other words, how can I see its query execution plan (creating temp work tables and such)? I remember in SQL Server its something like SHOW QUERY PLAN ON... Thanks, Sunil