Re: Clusters

The first table has about 200,000 rows , the second one about 300,000. I built cluster based on PK of the first table and FK of the second one. I tried to select 20,000 records.
Query on clustered tables was 10-15% slower than on ordinary tables

Gocha

Thomas Kyte wrote in message <3627fe76.4090822_at_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 - 20:29:07 CDT