Summary

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.

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.