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 ...