Welcome to MSDN Blogs Sign in | Join | Help

June 2006 - Posts

Friday, June 30, 2006 1:05 PM

Bookmark Lookup

In my last post, I explained how SQL Server can use an index to efficiently locate rows that qualify for a predicate. When deciding whether to use an index, SQL Server considers several factors. These factors include checking whether the index covers
Posted by craigfr | 14 Comments
Filed under:
Monday, June 26, 2006 2:40 PM

Scans vs. Seeks

Scans and seeks are the iterators that SQL Server uses to read data from tables and indexes. These iterators are among the most fundamental ones that we support. They appear in nearly every query plan. What is the difference between a scan and a seek?
Posted by craigfr | 3 Comments
Filed under:
Monday, June 19, 2006 10:20 AM

Properties of Iterators

In this post, I’ll give an overview of three interesting properties of iterators that can affect query performance: memory, non-blocking vs. blocking, and dynamic cursor support. Memory All iterators require some small fixed amount of memory to store
Posted by craigfr | 6 Comments
Tuesday, June 13, 2006 8:25 AM

Viewing Query Plans

In my last post, I explained that SQL Server executes a query by compiling it into an iterator tree which we call a query plan. So, if we want to understand iterators and query execution better, we need a way to look at query plans. Fortunately, SQL Server
Posted by craigfr | 1 Comments
Thursday, June 08, 2006 8:46 AM

The Building Blocks of Query Execution

What are iterators? SQL Server breaks queries down into a set of fundamental building blocks that we call operators or iterators. Each iterator implements a single basic operation such as scanning data from a table, updating data in a table, filtering
Posted by craigfr | 3 Comments
Wednesday, June 07, 2006 9:13 AM

Why am I starting this blog?

About two years ago I presented a talk to a couple of SQL Server user groups where I explained in general terms how SQL Server executes queries. I explained how to read showplan and how some of the most common operators (such as index scans and seeks,
Posted by craigfr | 5 Comments
 
Page view tracker