
62 3.2 Star Queries and Star Query Transformations
3.2 Star Queries and Star Query Transformations
Star queries and star query transformations are used to transparently change
the way queries are executed, typically between a single very large fact table
and multiple much smaller dimension tables in a data warehouse.
Note: Star queries were introduced many years ago in Oracle Database 7.
Star transformation queries, on the other hand, were introduced in Oracle
Database 8 and superseded star queries from Oracle Database 7. In the lat-
est versions of Oracle Database, the two terms both seem to describe an
Oracle Database 8 introduced star transformation ...