SQL优化基本规则..pptxVIP

SQL Optimization;DB2 table definition : from logical to physical;Automatic data distribution using hashing and partition map;Data partitioning - Goal 1 : ensure even data distribution across all partitions;Data distribution - Goal 2 : optimize join processing parallel query optimization;Colocation;Collocated Join;Broadcast Join;Directed outer table Join;Directed Inner-Table and Outer-Table Join Example;Insert/select;Partitioning Key Selection;SQL Optimization;;;;;;;;...;DESCRIPTION;;;;;;