Summary
It is important that you understand the basic ideas behind SQL Server indexes. In the next chapter, you build on the basic concepts of this chapter and learn about the Query Processor. If you understand indexes, the Query Processor, and the tools SQL Server provides to help you select the proper indexes, you will be able to provide valuable support to developers. Following are some important points to remember about SQL Server indexes:
SQL Server maintains indexes with a B-Tree structure.
In a clustered index, the leaf contains the actual data pages of the table, and the data is physically stored in the logical order of the index.
The SQL Server query optimizer can use more than one index to resolve a query.
SQL Server 2000 can maintain ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
