Currently Informix EXPLAIN generates a server side file. For developers that are working from remote machines, it becomes problematic to retrieve the explain files when they have restricted access to the Informix Server machine.
There are 2 undocumented functions that can be used but they have limited functionality : ifx_explain and bson_explain .
These functions return the optimizer plan, but cannot return a statistics section ( the sql statement is never actually executed, so there is no statistics section ).
Informix should be enhanced to allow a remote client to retrieve the output of the EXPLAIN plan and the statistics section.
Such capability would greatly benefits developers that have restricted access do the Informix server machine, has it happens in many corporate environments.
Why is it useful?
|Who would benefit from this IDEA?||Developers, DBAs|
How should it work?
In an agnostic way ( should work for dbaccess, jdbc, odbc, etc ), the explain output ( including statistics section ) should be made available to a remote client.
One possible way would be to enhance and document the already existing ifx_explain and bson_explain functions.
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions