Re: About indexes and clusters
Date: Fri, 7 Nov 2003 20:21:39 -0500
Message-ID: <vaGdnX7T0oHe2DGiRVn-hg_at_golden.net>
"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message
news: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.
Agreed. One really has to know what one is giving away and what one is getting in return. Received on Sat Nov 08 2003 - 02:21:39 CET