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.
[...] 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 UTC 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 UTC Aug 10,2010 |