In case you hadn’t noticed it, partitioning has finally reached clusters in 12c – specifically 22.214.171.124. They’re limited to hash clusters with range partitioning, but it may be enough to encourage more people to use the technology. Here’s a simple example of the syntax:
create cluster pt_hash_cluster ( id number(8,0), d_date date, small_vc varchar2(8), padding varchar2(100) ) -- single table hashkeys 10000 hash is id size 700 partition by range (d_date) ( partition p2011Jan values less than (to_date('01-Feb-2011','dd-mon-yyyy')), partition p2011Feb values less than (to_date('01-Mar-2011','dd-mon-yyyy')), partition p2011Mar values less than (to_date('01-Apr-2011','dd-mon-yyyy')) ) ;
I’ve been waiting for them to appear ever since 126.96.36.199 and the TPC-C benchmark that Oracle did with them – they’ve been a long time coming (check the partition dates – that gives you some idea of when I wrote this example).
Just to add choice (a.k.a. confusion) 188.8.131.52 has also introduce attribute clustering so you can cluster data in single tables without creating clusters – but only while doing direct path loads or table moves. The performance intent is similar, though the technology and circumstances of use are different.