Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: filetered index

Filtered Index – SQL Server 2008

Introduction: Filtered index concept is new feature added from SQL Server 2008. A filtered index is an optimized nonclustered index, especially suited to cover queries that select from a well-defined subset of data. It uses a filter predicate to index a portion of rows in the table.

Published November 19, 2008
Categorized as Performance Tunning Tagged dba, filetered index, indexes, performance

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.