jump to navigation

Filtered Indexes in SQL Server 2008 September 30, 2009

Posted by Arshad Ali in Database Administration, SQL Server 2008.
Filtered Indexes in SQL Server 2008
SQL Server 2008 introduces Filtered Indexes which is an index with a WHERE clause. Doesn’t it sound awesome especially for a table that has huge amount of data and you often select only a subset of that data? For example, you have a lot of NULL values in a column and you want to retrieve records with only non-NULL values or in another scenario you have several categories of data in a particular column, but you often retrieve data only for a particular category value. This article talks about what a Filtered Index is, how it differs from other indexes, its usage scenario, its benefits and limitations.


No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: