Discussion:
Informix 10 - EXPLAIN
(too old to reply)
g***@gmail.com
2016-04-07 15:12:33 UTC
Permalink
Raw Message
Informix 10
------------

I am a newbie to Informix. So my questions might be too basic.

I need to obtain the query plan for a SELECT. I am
using SQL Workbench y Server Studio to run the queries.

Is there a way in INFORMIX as in PostgreSQL or SQL Server to obtain the query plan in the client PC? If yes how?

Thank you in advance and sorry for my english!

Guillermo
Doug Lawry
2016-04-08 04:51:31 UTC
Permalink
Raw Message
Hi Guillermo.

In any SQL client, use one of the following statements:

SET EXPLAIN ON;
SET EXPLAIN ON AVOID_EXECUTE;

This creates sqexplain.out on the server in the user's home directory on Linux/UNIX or $INFORMIXDIR on Windows.

If you have a licence for Server Studio, there is a button to do this with AVOID_EXECUTE, retrieve the file, and display graphically.

Regards,
Doug Lawry

Loading...