Implementing Indexes

The topics in this section provide the information to help you create, modify, drop, and view indexes on tables and views.

In This Section

Topic

Description

Creating Indexes

Provides guidelines and examples specific to creating each SQL Server index type.

Modifying Indexes

Provides guidelines and examples to modify, disable, or rename an index.

Determining Index Disk Space Requirements

Provides guidelines and examples to determine the disk space required to perform index DDL operations.

Dropping Indexes

Provides specific guidelines and examples to delete an index.

Viewing Index Information

Explains methods to find detailed information about existing indexes. This includes index properties and options.