Filtered SQL Server 2008 Indexes

Question

I would like to understand the SQL Server 2008 filtered index feature.

How does the Database Engine work with this concept? And how does this help me get faster results than standard indexes when querying large tables?

Can someone help me with this?

Thanks.

Answer 1

This is a WHERE clause in your index.

My real life for the millionth row table:

• I need an index in a column in a table, but 90% of the values ​​are NULL. I need an index for 10% non-zero, but the index is inflated with 90% NULL. Therefore, I add a filter and save space.

• (eq NON-null). SQL Server 2008 . "WHERE"

Answer 2

, , - , .

, , , /. , .

, , , NC . - . , Filtered, , , ( ) - .

, , , , , .