Netezza planners are very important to improve the performance of the query that you fire onto Netezza performance server. Types of Netezza Planners There are different types planners that Netezza performance server uses: The Fact Relationship (factrel) planner Snowflake planner The Star planner The Fact Relationship (factrel) planner The Fact Relation Planner is a feature used to prevent large table re-distribution i.e. costly re-distribution or broadcasting of fact data when other alternatives may exist. Read: Data warehouse Star schema and Design Analyze and Optimize Netezza Query Performance Netezza Best Performance…

Netezza uses the cost based optimizer to determine the best methods for scan, join order and data movement between the SPUs. Planner uses the Netezza query plan to redistributed or broadcast your data. You can use EXPLAIN VERBOSE <your_quey> command to display the Netezza query plan. The planner always tries to avoid redistributing large tables because of the performance impact. Decisions about redistribution are made by the planner and are based on costs like expected table sizes. Optimizer also uses the Netezza query plan to dynamically rewrite queries to improve…