Chapter 9. Star Join Considerations

  1. Tapio Lahdenmäki and
  2. Michael Leach

Published Online: 27 JAN 2005

DOI: 10.1002/0471721379.ch9

Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al.

Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al.

How to Cite

Lahdenmäki, T. and Leach, M. (2005) Star Join Considerations, in Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al., John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/0471721379.ch9

Author Information

  1. Smlednik, Slovenia, Shrewsbury, England

Publication History

  1. Published Online: 27 JAN 2005
  2. Published Print: 24 JUN 2005

ISBN Information

Print ISBN: 9780471719991

Online ISBN: 9780471721376

SEARCH

Keywords:

  • star joins;
  • cartesian products;
  • cartesian joins;
  • dimension tables;
  • fact tables;
  • joins;
  • index design;
  • table access order;
  • QUBE;
  • star join limitations;
  • summary tables;
  • query tables;
  • data warehouse

Summary

An introduction to Star Joins by means of an example; the role of cartesian products, dimension tables and fact tables. A comparison of these issues with ordinary Joins. Index design for dimension and fact tables. The huge impact of the table access order with regard to the two types of table and with cartesian joins; comparisons made using the QUBE. The limitations of star joins and the use of Summary or Query Tables.