Query Plan Optimization with Star Joins

SAP ASE 16.0 introduces the use fact_table abstract plan hint, which specifies the central fact table in a star join query and triggers special query plan optimization strategies for the star join query.

The use fact_table abstract plan hint allows the query processor to chose a parallel hash join plan for the star join query. Parallel plans enable the query processor to push bloom filter probings (which allow for faster joins between dimension and fact tables) below the Xchg operator, further reducing the number of qualifying rows from fact tables