About This Blog

A copy of my content originally hosted on SQLBlog.com
Showing posts with label Bitmaps. Show all posts
Showing posts with label Bitmaps. Show all posts

Thursday, 7 July 2011

Bitmap Magic (or… how SQL Server uses bitmap filters)

Bitmap Magic (or… how SQL Server uses bitmap filters)

Question

Can a parallel query use less CPU than the same serial query, while executing faster?

The answer is yes! To demonstrate, I’ll use the following two (heap) tables, each containing a single column typed as integer:

Tables #BuiltInt and #Probe