Rich,
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@xxxxxxxxxxxxxxxxxxxxx>
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