Re: ORA-30009

I've fixed the queries, but xmltable is still fastest one. You can check it yourself:
https://gist.github.com/xtender/d900ee3ef37b6c06bb9020b31d1d39dd

I've also attached my results.

On Mon, May 16, 2016 at 9:19 PM, Rich J <rjoralist3_at_society.servebeer.com> wrote:

> On 2016/05/16 11:33, Sayan Malakshinov wrote:
>
> You can compare these variants on your oracle version:
> https://gist.github.com/xtender/d900ee3ef37b6c06bb9020b31d1d39dd
>
> I've got that last variant is fastest one on my home 11.2.0.4
>
>
>
> That's because the last 3 statements (with "xmltable") are operating on
> 10x less rows than the "connect by" example.
>
> Interesting thread here! :)
>
> Rich
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l