Partial Index View

Transact-SQL
1

Hi:

Is there something call partial index view in sql? This is suppose to
be a tech question for a interview. I find something on filter index.

Thank you
kmymickey

2

The 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. The technique of index feature comes with the SQL Server 2008 flavor.
To know more about the Prtial Index please move on this it may be helpful to you. http://www.postgresql.org/docs/9.3/static/sql-createindex.html