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.
Oracle Scratchpad 
[…] 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 |
[…] 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 |
[…] 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 |