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 ...
About the author
Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.
Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.