Netezza Planners: Different types of Planners
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…