Cannot resist: On page 379 of Effective Oracle by Design, Tom Kyte quotes Steve Adams as saying: “If a schema has no IOTs or clusters, that is a good indication that no thought has been given to the matter of optimizing data access.” Major New Undocumented Partitioning Feature in Oracle Database 11g Release 2 http://iggyfernandez.wordpress.com/2011/05/10/major-new-undocumented-partitioning-feature-in-oracle-database-11g-release-2/ Multidimensional Clustering (MDC) in Oracle Database http://iggyfernandez.wordpress.com/2011/03/26/multidimensional-clustering-mdc-in-oracle-database/ Relational joins are expensive by definition (NOT), therefore abandon the relational model (NOT) http://iggyfernandez.wordpress.com/2012/04/07/relational-joins-are-expensive-by-definition-not/ Oracle 12c Gives Fresh Life to the Relational Database Movement http://iggyfernandez.wordpress.com/2013/03/31/oracle-corporation-gives-fresh-life-to-the-relational-database-movement/ Day 9: The Twelve Days of SQL: Physical database design matters http://iggyfernandez.wordpress.com/2011/12/11/the-twelve-days-of-sql-day-9/ Apologies for plugging my own posts. Iggy -- //www.freelists.org/webpage/oracle-l