Re: Clusters

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 15 Oct 1998 13:55:24 GMT
Message-ID: <3627fe76.4090822@192.86.155.100>

A copy of this was sent to "Gocha Mchedlishvili" <gocham_at_mci2000.com> (if that email address didn't require changing) On Wed, 14 Oct 1998 20:45:52 -0400, you wrote:

>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
>

hows about some details? Whats the query, what do the tables look like. How are they indexed differently from 'regular' tables... In general -- Clusters aren't slower then regular tables, they aren't faster... They are a tuning device to be used when appropriate. What are you attempting to do?  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 15 1998 - 08:55:24 CDT