Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

What is Filtered Index?

Add comment
Views: 51
Votes: 0
Comments: 0
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.
Others in this Category
document Q: Please explain Outer Join in SQL
document What is Trigger?
document What is use of DBCC Commands?
document Q: What is pseudo columns ? Name them?
document What is OLTP (Online Transaction Processing)?
document Which are new data types introduced in SQL SERVER 2008?
document What is DataWarehousing?
document What command would you use to create a backup control file?
document Can SQL Servers linked to other servers like Oracle?
document What is RAISEERROR?
» More articles



RSS