Re: Index organised table

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1133740059.200758_at_jetspin.drizzle.com...
> Mark A wrote:
>> "DA Morgan" <damorgan_at_psoug.org> wrote in message
>> news:1133726635.508962_at_jetspin.drizzle.com...
>>
>>>clustering columns? b-tree clustered index?
>>>
>>>What product are you writing about? And why are you writing about it in
>>>c.d.o.server?
>>>--
>>>Daniel A. Morgan
>>
>>
>> Talking about a single table b-tree cluster in Oracle. The reference to a
>> b-tree clustered index was a typo.
>>
>> But you that, didn't you?
>
> And what, precisely, is a "single table b-tree cluster" in Oracle?
>
> A reference at http://tahiti.oracle.com would be appreciated.
>
> Yeah ... I believe you work with Oracle ... all the time. Sure. You
> betcha. Putting my money down on it right this very minute. Uh huh!
> --
> Daniel A. Morgan

How much?

If you want to learn more about Clusters, check out the Oracle Concepts, the section entitled "Overview of Clusters" (which on my PDF version of 10g Release 1 is on page 5-50). I have my own PDF copies and don't use the online manuals, so I don't have a link.

Even though the documentation only discuss clustering two tables together, you can actually just cluster one table and achieve the results I discussed earlier in this thread.

This technique (using only one table in a cluster) is discussed in one of Tom Kyte's books, which he calls "single table b*tree cluster," but I don't have an exact reference. You might be able to find some information on http://asktom.oracle.com

I can't believe that some people think you actually know anything about Oracle. You are a complete fraud. Received on Sun Dec 04 2005 - 19:24:56 CST