Filtered Index is a index created with where clause & used for query optimization.
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.
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.
CREATE NONCLUSTERED INDEX IND_Students
ON Test.Students(RollNumber)
WHERE DeptID = 1
No comments:
Post a Comment