Re: DBA - clustered tables - WHY ? - WHO USES THIS ?

nsouto_at_acay.com.au wrote:

>In <4toesm$2ai8_at_news-s01.ny.us.ibm.net>, roosens writes:
>>Could any point out the advantage- when you should use or more important when NOT to
>>use them.
>>How can you estimate the profit ?
>>How can you measure your profit after applying them ?
>
>Hmmm, ORACLE probably will kill me for saying this, but I only had success in using
>clusters in a fashion totally outside of what they recommend. Instead of using them
>to save join I/O, like ORACLE suggests, I used them to save space and cluster rows
>of the same key value (duplicated, of course) on the same ORACLE block. I.e,
>instead of clustering two tables, I just clustered a single table with a long key

Did you ever try clustering multiple tables? If so what was the result? I'm thinking of recommending them in a data warehouse. We've got two huge tables that are almost always accessed together. I thought they'd be a perfect fit for clusters.

Also, did you use indexed clusters or hashed clusters? (Sounds like a breakfast cereal doesn't it ;-) )

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself