Re: SET EXPLAIN QUESTION
When you use a PREPARE the engine optimises the query at PREPARE time only. Subsequent OPEN's do not re-optimise the query - (which is a good thing for performance). Therefore the answer to your question is no. You will only see the queries which have been optimised in the sqexplain.out file. You may want to check out an article I wrote about the optimiser (approx 12 pages). It can be found somewhere on the International Informix User Group Web pages (www.iiug.org). On 2 May 1996 12:53:18 -0400, ennis@ssax.com (Bill Ennis) wrote: >Hi, > >I have a rather specific question on the SET EXPLAIN output. >Does the output contain EVERY SQL command send to the engine >from the session whether its been previously PREPARE'd or >not? > >Thanks, >Bill >-- >Bill Ennis Voice: 312-474-7516 >SSA Fax: 312-474-7460 >500 W. Madison email: ennis@ssax.com (c) 1996, All rights reserved. __________________________________________________________ | o o | | Gavin Nour: nourg@acslink.net.au | | Director: Select Software Solutions Pty Ltd. | | Secretary: Informix User Group NSW, Australia. | | Committee member: International Informix User Group. | | Mobile: +(61) 0419 803 113 | | o o | |__________________________________________________________|