Re: transitive closure
Date: 20 Jul 2005 02:57:47 -0700
Message-ID: <1121853467.829969.218920_at_g43g2000cwa.googlegroups.com>
>> CONNECT BY. I know it's recursive internally. <<
I think CONNECT BY is still a hidden cursor doing a sequential tree traversal because the order of the results contrains information. If it were a relational operator the order would not matter, which is the case for WITH RECURSIVE in DB2.
>> I'm not as concerned about portability as Joe Celko is. <<
Stay unconcerned. Eventually management gets concerned with portability and I can make some big bucks helping them :).
The only ways I have found to avoid porting to a new release, new platform or new SQL are: (1) company goes broke - had a lot of that in recent years (2) the company has such useless code that nobody else wants it (3) the company has such bad code that it is cheaper to throw it out (4) the application never grows so things can stay fixed. Received on Wed Jul 20 2005 - 11:57:47 CEST