O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

General Principle Behind Indexes

Take a high-level look at how indexing can help speed up data retrieval. Figure 18.1 shows a single table called School Employee that lists the name and occupation of each employee in the school.

Figure 18.1. The School Employee table.

Using the table shown in Figure 18.1, what would you do if you wanted to select the names of all the people in the School Employee table who were janitors? You would have to read every row in the table and display only the names where the occupation in the row is Janitor. The process of reading every row or record in a table to satisfy a query is called a table scan. Now add an index ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required