Welcome to MSDN Blogs Sign in | Join | Help

October 2006 - Posts

Wednesday, October 25, 2006 12:40 PM

The Parallelism Operator (aka Exchange)

As I noted in my Introduction to Parallel Query Execution post , the parallelism (or exchange) iterator actually implements parallelism in query execution. The optimizer places exchanges at the boundaries between threads; the exchange moves the rows between
Posted by craigfr | 3 Comments
Filed under:
Wednesday, October 18, 2006 9:54 AM

Index Union

I was planning to continue writing about parallelism this week (and I will continue another time in another post), but I received an interesting question and chose to write about it instead. Let’s begin by considering the following query: create table
Posted by craigfr | 0 Comments
Filed under:
Wednesday, October 11, 2006 11:11 AM

Introduction to Parallel Query Execution

SQL Server has the ability to execute queries using multiple CPUs simultaneously. We refer to this capability as parallel query execution. Parallel query execution can be used to reduce the response time of (i.e., speed up) a large query. It can also
Posted by craigfr | 5 Comments
Filed under:
Wednesday, October 04, 2006 10:11 AM

Decorrelating Subqueries

In my previous post , we saw some examples where the optimizer is able to take a query with a correlated subquery and rewrite it as a join. For instance, we saw how this simple “in” subquery: create table T1 ( a int , b int ) create table T2 ( a int ,
Posted by craigfr | 1 Comments
Filed under:
 
Page view tracker