1. Data preparation

To study this course, the test data needs to be prepared first. You can generate test data using the program provided on the TPC official website or the method described in the article ‘Generate TPCH data using SPL’.

When preparing data, pay attention to data size occupied on the hard disk. Taking TPCH-Q1 as an example, in order to exercise the external storage calculations of big table, the lineitem.tbl should be slightly larger than memory. The memory of the test computer for this course is 8G, so the total data size selected is 15G, of which about 11G is the size of lineitem.tbl.

During the learning process, the total data size should be determined based on the memory of your computer.

2. Detailed case analysis

Performance optimization case course: TPCH-Q1

Performance optimization case course: TPCH-Q2

Performance optimization case course: TPCH-Q3

Performance optimization case course: TPCH-Q4

Performance optimization case course: TPCH-Q5

Performance optimization case course: TPCH-Q6

Performance optimization case course: TPCH-Q7

Performance optimization case course: TPCH-Q8

Performance optimization case course: TPCH-Q9

Performance optimization case course: TPCH-Q10

Performance optimization case course: TPCH-Q11

Performance optimization case course: TPCH-Q12

Performance optimization case course: TPCH-Q13

Performance optimization case course: TPCH-Q14

Performance optimization case course: TPCH-Q15

Performance optimization case course: TPCH-Q16

Performance optimization case course: TPCH-Q17

Performance optimization case course: TPCH-Q18

Performance optimization case course: TPCH-Q19

Performance optimization case course: TPCH-Q20

Performance optimization case course: TPCH-Q21

Performance optimization case course: TPCH-Q22