Oninit cdi / Archive
Talk to an expert →

Informix engin

Posted in 2007

Summary

Nandkishor Singare asked how to see what the engine does for a query, such as temp tables. Jack Parker and Art Kagel said to use SET EXPLAIN ON, which writes the plan to sqexplain.out. H.G added that on IDS 9.40 or later, onmode -Y with the session id and 1 or 0 turns explain on and off for a particular session.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Nandkishor Singare — — source: IIUG Forums & Mailing Lists

Hi, How to get the details of - what the informix engin is doing in background to get query results? like is it creating a temp table or not etc... Regards, Nandkishor

↪ replying to Nandkishor Singare
Jack Parker — — source: IIUG Forums & Mailing Lists

Start your query with set explain on; Results will be written sqexplain.out - location of that (and actually it's name) will vary with the OS and version of the engine you are using. See a manual near you for details. SQL Reference manual, SQL Syntax chapter. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of Nandkishor Singare Sent: Thursday, August 02, 2007 7:19 AM To: ids@iiug.org Subject: Informix engin [9680] Hi, How to get the details of - what the informix engin is doing in background to get query results? like is it creating a temp table or not etc... Regards, Nandkishor **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Nandkishor Singare
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

SET EXPLAIN ON;SELECT .... ; SET EXPLAIN OFF; The query plan will be written to the file sqexplain.out in your home directory on the server host. Art S. Kagel ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 8/02 7:19:26 Hi, How to get the details of - what the informix engin is doing in background to get query results? like is it creating a temp table or not etc... Regards, Nandkishor ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to ART KAGEL, BLOOMBERG/ 731 LEXIN
H.G — — source: IIUG Forums & Mailing Lists

IDS version ? If IDS 9.40 or later and want to check a specified session, you can also use onmode -Y <SID> 1 and onmode -Y <SID> 0 Cheers. "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net> wrote: SET EXPLAIN ON;SELECT .... ; SET EXPLAIN OFF; The query plan will be written to the file sqexplain.out in your home directory on the server host. Art S. Kagel ----- Original Message ----- From: Nandkishor Singare At: 8/02 7:19:26 Hi, How to get the details of - what the informix engin is doing in background to get query results? like is it creating a temp table or not etc... Regards, Nandkishor ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.