Re: database design method
From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: 10 Nov 2002 11:33:46 -0800
Message-ID: <e9d83568.0211101133.433a6bb9_at_posting.google.com>
Date: 10 Nov 2002 11:33:46 -0800
Message-ID: <e9d83568.0211101133.433a6bb9_at_posting.google.com>
Jan,
> Very good point, and it made me realize that I should have known the answer
> myself. The answer consists probably of two parts:
>
> 1. There are special efficient algorithms available to the query optimizer
> for the transitive closure. And because it is not easy for the optimizer
> to always recognize when a general recursive query computes a transitive
> closure it is useful if the user indicates this explicitly.
>
> 2. The same probabaly holds for the human reader who can now more easily
> understand what it is that is computed.
>
That sounds like a good answer to me!
regards,
Lauri Pietarinen
Received on Sun Nov 10 2002 - 20:33:46 CET