Re: ORA-30009

  • From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 16 May 2016 13:19:51 -0500

 

On 2016/05/16 11:33, Sayan Malakshinov wrote: 

You can compare these variants on your oracle version: 
https://gist.github.com/xtender/d900ee3ef37b6c06bb9020b31d1d39dd [1] ;

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 

Links:
------
[1] https://gist.github.com/xtender/d900ee3ef37b6c06bb9020b31d1d39dd

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2016