Star transformation in snowflaked schema with compound keys

Uli Bethke Oracle

This article builds on Mark Rittman's recent post on explain plans for star transformation. Every now and again I have come across claims that the CBO only uses star transformation with single part foreign keys on the fact table: "In order for a RDBMS query optimizer to execute a query using a Star Transformation, a single part foreign key with ...