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 commentary 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.

 

2 Comments »

  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


RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 4,015 other followers