Re: Set explain utility

Posted in 1997

Rudy Fernandes — Sat, 21 Jun 97 03:57:03 GMT — source: Informix-list mailing list archive (1991-1998)

>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. ---------------------- Rudy Fernandes GIC, Kuwait OL 7.20, 4Gl 6.04 ----------------------