Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: clustered index

Index usage

I have used the Contact table with person schema which is residing in AdventureWorks database for testing the index usage. I am describing the scenarios and places where index seek or scan will be used.

Published December 27, 2008
Categorized as Performance Tunning Tagged clustered index, indexes, non clustered index, 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.