Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

Indexes How-to Topics

To create efficient indexes that improve the performance of your database application by increasing the speed of your queries, you need an understanding of how to create and maintain the indexes on the tables in your database.

In This Section

  • How to: Delete an Index (SQL Server Management Studio)

  • How to: Modify an Index (SQL Server Management Studio)

  • How to: Move an Existing Index to a Different Filegroup (SQL Server Management Studio)

  • How to: Rebuild an Index (SQL Server Management Studio)

  • How to: Reorganize an Index (SQL Server Management Studio)

  • How to: View All Indexes in a Table (SQL Server Management Studio)

  • How to: View the Properties of an Index (SQL Server Management Studio)

See Also

Other Resources

Understanding Indexes

Designing and Implementing Structured Storage How-to Topics


Additional resources


  • Last updated on 2012-10-04

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026