Re: About indexes and clusters
From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Fri, 7 Nov 2003 16:52:08 -0800
Message-ID: <pgXqb.11$FN1.154_at_news.oracle.com>
Date: Fri, 7 Nov 2003 16:52:08 -0800
Message-ID: <pgXqb.11$FN1.154_at_news.oracle.com>
"Bob Badour" <bbadour_at_golden.net> wrote in message
news:HqednfYNFak5qzGiRVn-tw_at_golden.net...
> > IMO, clustering of the data is not such a good idea. Clusters are source
> of
> > bugs (as just yet another feature, that database implementors should
take
> > care of), and contrary to popular belief don't improve the performance.
>
> Is it not true that they make some operations faster at the cost of making
> other operations slower?
Certainly. So does almost any other implementation feature. Indexes, for example. The question is if the performance gain is worth the hassle. Received on Sat Nov 08 2003 - 01:52:08 CET