iggyfernandez.wordpress.com
The way you write your query matters: Performance comparison between CONNECT BY and recursive subquery factoring
I was asked to compare the performance of traditional CONNECT BY syntax with recursive subquery factoring (a.k.a. recursive common table expressions) but I only have part of the answer. To summariz…