Home, Parent TPC-H Interim
Below are the TPC-H SF100 plan costs and actual time.
| Query | Plan Cost DOP 1 | Plan Cost Parallel | FusionIO (sec) | Plan Cost- Actual ratio |
|---|---|---|---|---|
| Q1 | 11,685.5 | 9,124.2 | 42.2 | 216.21 |
| Q2 | 621.1 | 551.1 | 0.6 | 918.53 |
| Q3 | 1,995.7 | 1,233.5 | 4.3 | 286.85 |
| Q4 | 1,449.7 | 1,147.8 | 2.1 | 546.59 |
| Q5 | 3,960.2 | 3,027.4 | 5.0 | 605.48 |
| Q6 | 1,476.7 | 1,315.4 | 1.5 | 876.94 |
| Q7 | 5,516.7 | 3,749.5 | 4.1 | 914.52 |
| Q8 | 6,062.1 | 4,490.2 | 5.1 | 880.42 |
| Q9 | 24,960.7 | 12,625.0 | 44.1 | 286.28 |
| Q10 | 3,234.6 | 1,572.3 | 3.0 | 524.11 |
| Q11 | 3,410.4 | 2,454.2 | 2.2 | 1115.52 |
| Q12 | 6,755.1 | 5,930.6 | 5.2 | 1140.50 |
| Q13 | 3,995.8 | 2,556.6 | 23.6 | 108.33 |
| Q14 | 692.7 | 477.2 | 1.3 | 367.10 |
| Q15 | 569.0 | 416.8 | 1.6 | 260.50 |
| Q16 | 1,957.2 | 838.2 | 7.2 | 116.42 |
| Q17 | 2,282.1 | 2,243.6 | 0.8 | 2804.51 |
| Q18 | 38,141.8 | 15,875.6 | 35.2 | 451.01 |
| Q19 | 5,176.3 | 4,939.1 | 2.4 | 2057.95 |
| Q20 | 1,541.0 | 1,484.7 | 1.6 | 927.96 |
| Q21 | 38,574.1 | 29,421.4 | 30.2 | 974.22 |
| Q22 | 3,294.3 | 2,636.2 | 6.1 | 432.17 |
| Total | 167,353 | 108,111 | 229.4 | 471 |