O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

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

Types of Indexes

SQL Server can create twogeneral types of indexes:

  • Regular SQL Server indexes, which are created by Transact-SQL commands and maintained automatically by SQL Server. Query Optimizer uses these indexes to speed the execution of queries.

  • Full-text indexes, which are created by system-stored procedures, managed by the Microsoft Search Service, and accessed by specific Transact-SQL extended commands. Query Optimizer doesn't use full-text indexes automatically to optimize the execution of queries.

Full-text indexes are used by specific Transact-SQL functions. This type of index is out of the scope of this book, but you can get information about them in Books Online.

This chapter covers in detail the regular SQL Server indexes because ...

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