Re: Clusters

From: Sylvain Leclerc <SLeclerc_at_magrit.com>
Date: Thu, 15 Oct 1998 08:24:58 -0400
Message-ID: <044CD796C702D111B56800608CCC51D0093A47@INT_04>

Clusters are a "stored" join querry. If you don't use the data with that particular join query you may
indeed encounter a slower response time. Clusters should be used for tables that are almost ALLWAYS
queried together.

Sylvain Leclerc
sleclerc_at_magrit.com

> -----Original Message-----
> From: Gocha Mchedlishvili [SMTP:gocham_at_mci2000.com]
> Posted At: Wednesday, October 14, 1998 8:46 PM
> Posted To: server
> Conversation: Clusters
> Subject: Clusters
>
> Hi,
>
> I created cluster and then two tables, using the cluster.
> But query on the tables is slower, than on tables with ordinary
> indexes.
> Does anybody know why?
>
> I'm running ORACLE 8.05 on Solaris 2.6
>
> Thanks
>
> Gocha
>
Received on Thu Oct 15 1998 - 07:24:58 CDT