Summary
Congratulations, you made it to the end of the day. In this lesson, you have learned quite a bit about indexes, what different types exist, and how to create them. In addition, you also took a quick look at some of the tools available to you to see how the server executes a query and what statistics are generated when the query is run. Finally, you saw how the Execution Plan option in the Query Analyzer displays graphically how the server actually executes a query.
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition 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.
