Index creation is an important part of managing a database. Creating useful indexes can vastly improve query performance and should not be overlooked. Fortunately, SQL Server 2012 makes the creation and management of indexes quite easy.
In Chapter 22, “Implementing Data Integrity,” you see how you can use indexes and other methods to enforce data integrity. Subsequent chapters cover the internal working of indexes and give you more insight into their role in performance.