Re: Dreaming About Redesigning SQL

From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: Tue, 21 Oct 2003 21:28:41 +0300
Message-ID: <bn3tve$qln$1@nyytiset.pp.htv.fi>

Bob Badour wrote:

>"Lauri Pietarinen" <lauri.pietarinen_at_atbusiness.com> wrote in message
>news:3F94BCBB.7030001_at_atbusiness.com...
>
>
>>I could now denormalise OrderDetail so that it contains cust_id also
>>and cluster by cust_id
>>(might cause you trouble down the road, if you can change the customer
>>of an order), in which case, with 3 I/O's I would get
>>- 8 customer rows
>>- 16 order rows
>>- 24 order detail rows (which would all apply to one customer)
>>
>>
>
>Depending on block size, by clustering the three tables together, one might
>get all of those rows for a single read potentially improving on Wol's
>numbers by a factor of eight or more for this one query. Of course, doing so
>would increase the cost of a table scan on the customer table.
>
>

Which DBMS'es support clustering of mutiple tables except for Oracle? Is this feature really used any more?
I thought it was more trouble than worth.

regards,
Lauri Received on Tue Oct 21 2003 - 13:28:41 CDT