| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Some experience using hash clusters?
Hi Juan,
It's true. Hash clusters (and index clusters and IOT's) can reduce the number of IO's required under the right circumstances. Lots of good examples in the Oracle documentation. When we wrote the DBA materials for version 7.0 (where I wrote the dreadful Integrity Constraints chapter) we didn't know very much about hash and index clusters. Now we do. Check out sql.bsq or experiment yourself. All of these features are under-utilized. As Steve Adams once remarked: If a design doesn't show the usage of at least one IOT it's probably not a good design.
Mogens
Juan Carlos Reyes Pacheco wrote:
> Hi list,
> some time ago I knew using clusters was not a good idea.
> Now I read hash clusters can reduce i/o because no index lookup are
> necessary.
>
> Could you please share your experience aobut the use of hash cluster.
>
> Thanks
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jun 22 2004 - 17:05:30 CDT
 |
 |