Re: Set explain utility

Hi Mark, concerning your question, please read the "Informix Guide to SQL: Syntax" Chapter 1, "SET EXPLAIN" There you will find the following: Usage The SET EXPLAIN statement executes during the database server optimization phase, which occurs when you initiate a query. For queries associated with a cursor, if the query is prepared and does not have host variables, optimization occurs when you prepare it; otherwise, it occurs when you open the cursor. ^^^^^^^^^ ... So, what I told you is not only described, it's the truth, too. MarkDenham@aol.com wrote: > > David > > Its a pity that it is like this, makes it harder to automate the profiling > without > impacting on live activity. > > Mark > MarkDenham@aol.com (home) > Denham.M@amstr.com (work) Hope this will end the discussion !!! Bye Stefan