Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Saturday, December 29, 2012

What is Filtered Index in SQL Server 2008

Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. When we see an Index created with some where clause then that is actually a FILTERED INDEX.

No comments:

Post a Comment