Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
COMP.DATABASES.INFORMIX
Informix 10 - EXPLAIN
From
guillermovil@gmail.com
@21:1/5 to
All
on Thu Apr 7 08:12:33 2016
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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
From
Doug Lawry
@21:1/5 to
All
on Thu Apr 7 21:51:31 2016
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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Guest
Sun Jun 15 18:58:11 2025
from
No
via
SSH
Plume
Sun Jun 15 15:01:03 2025
from
Uk
via
SSH
Centurion
Sun Jun 15 09:44:59 2025
from
Berea, Ohio
via
Telnet
Deasl
Sun Jun 15 08:43:59 2025
from
Foo, Bar
via
SSH
Deasl
Sun Jun 15 08:41:06 2025
from
Foo, Bar
via
SSH
Plume
Sat Jun 14 21:49:07 2025
from
Uk
via
SSH
Max Prime
Sat Jun 14 16:47:41 2025
from
United Kingdom
via
SSH
Deasl
Sat Jun 14 16:38:22 2025
from
Foo, Bar
via
SSH
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
493
Nodes:
16 (
2
/
14
)
Uptime:
175:10:50
Calls:
9,705
Calls today:
5
Files:
13,736
Messages:
6,178,849