Chapter 13. Creating and Managing Indexes
by Paul Jensen
IN THIS CHAPTER
Types of Indexes
Creating Indexes Using T-SQL
Creating Indexes Using Enterprise Manager
Managing Indexes
Dropping Indexes
The previous chapter, “Creating and Managing Tables in SQL Server,” discussed the creation of tables, a structure in which to store your data. The data in a table is stored in no particular order—in fact, it's referred to as a heap. To find a particular piece of data, the entire heap must be scanned. This is known as a full table scan, and it is analgous to this book having no index or table of contents. Every time you wanted to find information on tables, for instance, you would have to start at page 1 and flip through the entire book to make sure you retrieved ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.