Re: SET EXPLAIN QUESTION

Bill Ennis (ennis@ssax.com) wrote: : 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? The output from EXPLAIN will output things which require a selection criteria: SELECT, UPDATE, and DELETE. (ie. things with a WHERE clause). Things such as INSERT, UPDATE STATISTICS, FETCH, etc. do not show. If you do not PREPARE your statements, they will show up in the explain file every time you execute them. If you PREPARE them, they show up the first time you execute them. Or, in the case of a DECLARE'd cursor, they show up when you OPEN that cursor. They won't show up each time you OPEN the cursor, just the first time. __________________________________________________________________________ Joel Schumacher JCPenney Co. - UNIX Network Systems jschumac@uns-dv1.jcpenney.com 12700 Park Central Pl (214) 591-7543 Dallas TX 75251