White Papers

23 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series
Storage Arrays
One user power test query response time (seconds) comparison Table 4
Queries
LineItem Table -
Four Partitions
LineItem Table-
Eight Partitions
Pricing summary report query (Q1) 335.678 355.918
Minimum cost supplier query (Q2) 11.893 1.158
Shipping priority query (Q3) 291.178 292.457
Order priority checking query (Q4) 348.959 408.225
Local supplier volume query (Q5)
363.942
313.058
Forecasting revenue change query (Q6)
204.53
78.346
Volume shipping query (Q7)
333.83
239.192
National market share query (Q8) 442.987 433.611
Product type profit measure query (Q9) 572.652 544.943
Returned item reporting query (Q10) 348.855 302.482
Important stock identification query (Q11) 192.573 187.735
Shipping modes and order priority query (Q12) 444.854 384.98
Customer distribution query (Q13) 107.131 146.968
Promotion effect query (Q14) 997.375 104.46
Top supplier query (Q15)
202.146
118.025
Parts-supplier relationship query (Q16)
39.37
35.557
Small-quantity-order revenue query (Q17) 3.93 3.665
Large volume customer query (Q18) 330.447 312.85
Discounted revenue query (Q19) 46.229 48.17
Potential part promotion query (Q20) 246.154 148.975
Suppliers who kept orders waiting query (Q21) 1081.497 957.511
Global sales opportunity query (Q22) 63.022 58.281
The bold queries (Q1, Q3, Q6, Q7, Q12, Q14, Q15 and Q20) use the partition column l_shipdate in their
where clause. The response times for the queries in blue (in the four partition column) improved with the