Index creation is an important part of managing your database. Creating useful indexes can vastly improve query performance, but you must also consider the impact that indexes can have on data manipulation and disk space. In the next chapter, "Implementing Data Integrity," you will see how indexes are used to enforce data integrity through constraints, and subsequent chapters will show how to fine-tune your indexes for the best possible performance.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features