Re: transitive closure

From: mAsterdam <>
Date: Tue, 19 Jul 2005 16:30:04 +0200
Message-ID: <42dd0e6f$0$65378$>

David Cressey wrote:
> Marshall Spight wrote:
>>Anyone have any experience with Oracle's CONNECT BY?

I only toyed with it. No production use (AFAIK - maybe some development team started using it last month, in one of hundreds of instances I'm not monitoring).

>>Is it the right abstraction? Too narrow? Too broad?
>>Does it work well?

> Oracle's CONNECT BY has worked well for me, at a very practical level.
> However, I prefer to think of it as a PROCESS tool than as a DATA tool. If
> I want the classical model of child parent relationships, I'll use a
> foreign key to the parent. If I want the processing benefits of nested
> sets, I'll use nested sets.
> And if I want to be able to traverse a tree that's represented by a
> child-parent foreign key, I'll use CONNECT BY. I know it's recursive
> internally. But I don't have to think recursively to use it.
> I'm not as concerned about portability as Joe Celko is.

Do you also use it in constraints? Received on Tue Jul 19 2005 - 16:30:04 CEST

Original text of this message