Home

Interim Articles

I have not had time to do this properly, but for now here they are.

TPC-H SF 100 Query Plans, non-parallel

TPC-H SF 100 Query Plans, parallel

Date Correlation Optimization

SQL Server 2005 TPC-H SF 1 Query Plans, non-parallel

TPC-H SF 100 Execution Plans

Below are TPC-H SF 100 execution plans if any cares to examine them in detail. Do not click the link as the files are sqlplan files. I gave them an html extension for the website to allow downloads. Right click and save target.

TPC-H SF100 plans Non-parallel, no date correlation

TPC-H SF100 plans Non-parallel, with date correlation

TPC-H SF100 plans Parallel, no date correlation

TPC-H SF100 plans Parallel, with date correlation

TPC-H SF100 plans Query 3 non-parallel

TPC-H SF100 plans Query 4 non-parallel

TPC-H SF100 plans Query 5 non-parallel

TPC-H SF100 plans Query 5 parallel

TPC-H SF100 plans Query 7 non-parallel

TPC-H SF100 plans Query 8 non-parallel

TPC-H SF100 plans Query 10 non-parallel