Skills

• Learn performance optimization skills from TPCH tests

• Performance optimization skill: orderly grouping

• Performance optimization skill: Joining Big Fact Data and Big Dimension Data

• Performance optimization skill: Joining Small Fact Data and Big Dimension Data

• Performance optimization skill: Attached Table

• Performance optimization skill: Order-based Targeted MERGE

• Performance optimization skill: Order-based MERGE

• Performance optimization skill: Pre-Joining

• Performance optimization skill: For Dimension Table Filtering & Computation

• Performance optimization skill: Numbered Foreign Key

• Performance optimization skill: Pre-Joining of Dimensions

• Performance optimization skill: Reuse of traversing result to speed up multiple grouping

• Performance optimization skill：TopN

Course

• Performance optimization - Search

• Performance optimization - Traversal

• Performance optimization - Join

• Performance optimization - Multidimensional analysis

Examples

• Parallel computation of external data by esProc

• Query of Large Quantity of Random Key Values in Big Data

• Fetch data in parallel Improving Data Reading Performance

• SPL Examples of Implementing & Optimizing SQL IN & EXISTS