DB2 employs a star join when it detects that the query is joining tables that are a part of a star schema design of a data warehouse.
Note: The star join is indicated with the value of S in the JOIN_TYPE column of the PLAN_TABLE.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|