Home > SQL Server > SQL Server 2008 – Filtered Index

SQL Server 2008 – Filtered Index

Granted that SQL 2012 is already out, there is actually a feature inside SQL 2008 which is especially useful for some form of slice and dice when you have too much data.


This feature is called Filtered Index. You can find more information about it at http://technet.microsoft.com/en-us/library/cc280372.aspx.


Generally the purpose is to improve query performance by storing indexes only for a subset of the data. Additionally it reduces costs and storage incurred with index maintenance.


The syntax to create one is as follows

create unique nonclustered index [IndexName] on dbo.[TableName]([Fields])
where [Conditions]

Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: