Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Exercises

Image

What You Will Do Within This Workshop

Within this workshop you will:

Image Build several SQL statements which include joins and observe the various execution plans that are selected.

Image Observe many of the operations we have discussed actually being used within execution plans.

OPERATIONS-1

Images Within the next several exercises we will list a SQL statement to be executed and invite you to execute the statement on your own database and then use your preferred method of explaining the statement to review the execution plan. Do your best to decipher the individual steps of the execution plan selected from the Optimizer of your workshop database and reconcile these operations with the explanations provided within the lecture notes of this section.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint