Re: Oracle Clusters
Date: 1995/04/28
Message-ID: <1995Apr28.114035.9997_at_newton.ccs.tuns.ca>#1/1
In article <3nlbto$d30$3_at_mhadf.production.compuserve.com> Don Burleson <76443.2751_at_CompuServe.COM> writes:
>I heard a rumor that Oracle clusters are not as beneficial as
>folks would have us believe.
>
>Does anybody have any feedback?
>
>MTIA,
>
>Don Burleson
>dburleso_at_paychex.com
>
>--
>eieio
You can use clusters, but I find it easier to use indexes. Whatever you do, DON'T MIX ON SAME TABLE!!!!!!!!!!!!!! This will kill performance!!!!!!!!!!!!!!!
I had a table with both an index and a cluster.
I ran an *.SQL script (with quite a few UPDATES) which took 20 min.
I got rid of the cluster,
(if I remember well, I had to recreate the table and index)
and the script ran in under 2 min.
I've stayed away from clusters since then.
James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!"
Received on Fri Apr 28 1995 - 00:00:00 CEST