수안이의 컴퓨터 연구실
Goetz Graefe
Microsoft, Redmond, WA 98052-6399
GoetzG@Microsoft.com
Abstract
Microsoft SQL Server was successful for many years for transaction processing and decision support workloads with neither merge join nor hash join, relying entirely on nested loops and index nested loops join. How much difference do additional join algorithms really make, and how much system performance do they actually add? In a pure OLTP workload that requires only record-to-record navigation, intuition agrees that index nested loops join is sufficient. For a DSS workload, however, the question is much more complex. To answer this question, we have analyzed TPC-D query performance using an internal build of SQL Server with merge-join and hash-join enabled and disabled. It shows that merge join and hash join are both required to achieve the best performance for decision support workloads.
Microsoft, Redmond, WA 98052-6399
GoetzG@Microsoft.com
Abstract
Microsoft SQL Server was successful for many years for transaction processing and decision support workloads with neither merge join nor hash join, relying entirely on nested loops and index nested loops join. How much difference do additional join algorithms really make, and how much system performance do they actually add? In a pure OLTP workload that requires only record-to-record navigation, intuition agrees that index nested loops join is sufficient. For a DSS workload, however, the question is much more complex. To answer this question, we have analyzed TPC-D query performance using an internal build of SQL Server with merge-join and hash-join enabled and disabled. It shows that merge join and hash join are both required to achieve the best performance for decision support workloads.
The Value of Merge-Join and Hash-Join in SQL Server.pdf"MSSQL" 카테고리의 다른 글
- SQL Server Hardware Tuning and Performance Moni... (0)2007/07/25
- SQL Server 2005에서 TRY/CATCH를 사용하여 교착... (0)2007/07/23
- The Value of Merge-Join and Hash-Join in SQL Se... (0)2007/06/22
- Microsoft SQL Server 2000 Distributed Queries:... (0)2007/06/22
- SQL Server 2005에서 XML 데이터 형식을 위한 성능... (0)2007/05/25
Leave your greetings.