Workshop

The Workshop provides quiz questions to help you solidify your understanding of the material covered and exercises to provide you with experience in using what you've learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, "Answers to Quizzes and Exercises," and make sure that you understand the answers before continuing to the next lesson.

Quiz

1:Which is larger, a nonclustered or clustered index?
2:How do you force a table scan in SQL Server?

Exercises

1:Write a query to output the contents of the Employees table in the Northwind database. Display the Execution Plan for this query.
2:Add a WHERE clause to the query based on the LastName column and see whether the execution plan has changed.
3:Force the use of the nonclustered index on the PostalCode. Check the execution plan to see what the effect is.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset