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@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 - 13:33:46 CST