User Id :    Password :      New Member   Forgot Password  
Topic: What is Filtered Index in SQL
Sachin Jain
29 Oct 2010 at 11:08 PM
What is Filtered Index in SQL.
Re: What is Filtered Index in SQL
01 Nov 2010 at 12:25 AM

This index is used when we have to index some of rows in table this helps to increase performance and also reduce cost done by index on all the rows. When we see an Index created with some where clause then that is actually a FILTERED INDEX.

For Example,
If we want to get the Employees whose Title is “Marketing Manager”, for that let’s create an INDEX on EmployeeID  whose Title is “Marketing Manager” and then write the SQL Statement to retrieve Employees who are “Marketing Manager”.
CREATE NONCLUSTERED INDEX NCI_Department ON HumanResources.Employee(EmployeeID) WHERE Title= 'Marketing Manager'

Total Replies: 1
Featured Text Ad

Featured Ad