Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: About indexes and clusters

Re: About indexes and clusters

From: Bob Badour <bbadour_at_golden.net>
Date: Fri, 7 Nov 2003 20:21:39 -0500
Message-ID: <vaGdnX7T0oHe2DGiRVn-hg@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 Fri Nov 07 2003 - 19:21:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US