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

Index Enhancements in SQL Server 2000

SQL Server 2000 providessome important index enhancements over previous versions:

  • It is possible to create indexes in views. This feature can speed up the process of repetitive queries using aggregate functions or multiple joins. This topic is covered in the section "Indexed Views," later in this chapter.

  • It is possible to create indexes on computed columns, providing faster retrieval and sorting for data calculated dynamically. This topic is cov ered in the "Indexes on Computed Columns" section, later in this chapter.

  • You can define the index on ascending or descending order. If you have a composite index, every field can be ordered in ascending or descending order independently. Composite indexes are covered ...

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