Star Query Process
A Star query is a join between a fact table and a number of dimension tables.
- Each dimension table is joined to the fact table using a primary key to foreign key join
- The dimension tables are not joined to each other
- The Oracle 11g cost-based optimizer recognizes star queries and generates the most efficient execution plans for them
Ad Data Mining Business Analytics