Re: single table hash clusters in 9.2 - anyone tried them out yet?

I wish I could have gone.

I have used almost every object that you had mentioned at some point in time. I personally have found that you have to test to find out what works best. I'm not sure why, but single table hash clusters are sometimes faster than index lookups and sometimes they are slower. Maybe they covered that at the symposium. :)

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0403120939.39511a5a_at_posting.google.com>...
> If you attended Steve Adams presentation yesterday at the Hotsos
> Symposium, you probably have quite a list of new methods (not tips and
> tricks) that you are looking forward to test and possibly introduce
> into your environment.
>
> I wanted to open this thread for anyone that cared to share their
> results from moving from heap tables + b+tree indexes to either IOTs,
> index clusters, hash clusters or single table hash clusters.
>
> still seeing block dumps when I close my eyes ...
>
> Pd
Received on Fri Mar 12 2004 - 16:46:14 CST