Oracle Scratchpad

May 5, 2008

Hash Clusters – 1

Filed under: Infrastructure,Performance,Tuning — Jonathan Lewis @ 7:36 pm BST May 5,2008

Someone posted a question on the Oracle Forum yesterday about single table hash clusters, and I’ve given some initial comments on the topic.

Since this might be generally useful – and since there’s quite a lot more that could (and probably will) be said on the topic I thought I’d put a link to my respone here.



  1. […] some other comments I’ve made about hash clusters in the past: Hash Clusters – 1: also references a link on OTN where I’ve made a couple of comments Sorted Hash Clusters: An […]

    Pingback by Hash Clusters – 2 « Oracle Scratchpad — October 5, 2009 @ 9:15 pm BST Oct 5,2009 | Reply

  2. […] this query I created my second table as a “single table hash cluster” so, if I’ve done a perfect job (and been a bit lucky), for each row selected from the first […]

    Pingback by Joins – HJ « Oracle Scratchpad — August 10, 2010 @ 6:46 pm BST Aug 10,2010 | Reply

  3. […] you create a critical table as a single table hash cluster you can access all the rows for a single key value very quickly if you pick a block size that will […]

    Pingback by Block Sizes | Oracle Scratchpad — July 6, 2020 @ 11:20 am BST Jul 6,2020 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: