Re: Set explain utility

In article <5ofjd7$5fv$3@gulfa.kuwait.net>, rferdy@kuwait.net (Rudy Fernandes) wrote: > >>The sqexplain.out file exists immediately after the prepare. >>Please, try it again. > >How can this be? At the PREPARE stage (for any real-life query) >crucial information - values to use - are still missing. > >It is only at OPEN CURSOR when we tell the engine the values, and >only then can sensible optimization of the query be done. > >However, this is just theoretical. I will check it out in practice. Following a quick check on my OL7.2, I find that in fact the following occurs 1. WHERE clause values exist (i.e no ?s in PREPAREd string) Query plan defined at PREPARE (and outputted to sqexplain.out) 2. WHERE clause values undefined (?s exist in PREPAREd string) Query plan defined at OPEN CURSOR. Optimizer : keep up the good work. ---------------------- Rudy Fernandes GIC, Kuwait OL 7.20, 4Gl 6.04 ----------------------