Help Center/ Data Warehouse Service / Performance White Paper (8.1.3.x)/ Test Result/ TPC-H Single Query Test
Updated on 2025-10-23 GMT+08:00
View PDF
Share

TPC-H Single Query Test

Test Environment

Table 1 Test environment

Product

Flavor

vCPUs

Memory

Storage

Recommended Storage for a Single Node

Query Performance (TPC-H 1000X)

Version

Nodes

DWS

8xlarge

32 vCPUs

256 GB

Cloud SSD

6,400 GB

596.90s

8.1.3

3

Test Result

The following is the TPC-H performance test result. (scale=1000, time unit=s)

Table 2 TPC-H 1000X test result

ID

TPC-H Query

Test Result (s)

1

Q1

22.15

2

Q2

2.65

3

Q3

28.29

4

Q4

49.07

5

Q5

44.45

6

Q6

1.24

7

Q7

33.26

8

Q8

32.10

9

Q9

112.67

10

Q10

20.63

11

Q11

6.49

12

Q12

13.73

13

Q13

20.61

14

Q14

3.10

15

Q15

3.45

16

Q16

7.77

17

Q17

16.97

18

Q18

81.23

19

Q19

16.74

20

Q20

16.99

21

Q21

53.11

22

Q22

10.20

23

Total duration (s)

596.90
Parent topic: Test Result