Re: Explain Plan for queries

Rajib Sarkar wrote: > Actually in 9.30 there's an optimizer directive AVOID_EXECUTE which will > provide the explain plan without executing the query. You can also set it > using SET EXPLAIN ON AVOID_EXECUTE (pls check the syntax though). Ah, bollocks. The documentation doesn't stand still long enough for me to read it, even if _could_ be bothered. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"

Obnoxio The Clown wrote: > > Ah, bollocks. The documentation doesn't stand still long enough for > me to read it, even if _could_ be bothered. Ooooh, you little dog in a manger you.