Monday, August 1, 2011

Filtered indexes in sql server 2008

Just read a blog of Amit Bansal about Filtered indexes.
This is a really good feature.
You can create indexes on only a set of data like this:

create index on table(col1) where col1>234

Using this we can actually filter out the old data which is not used frequently and create index only on the current live data.

You can check the article here:
http://technet.microsoft.com/en-us/library/cc280372.aspx

No comments:

Post a Comment