Workshop

[ Team LiB ]

Workshop The purpose of the workshop is to allow you to test your knowledge of the material covered in the lesson. See whether you can successfully answer the questions in the quiz and complete the exercises before you continue with the next lesson. The answers to the quiz questions are provided in Appendix B. Quiz 1: What do you need to create an access plan graph? 2: What's an operator? How is it shown on an access plan graph? 3: When is it recommended that you collect statistics and reorganize a table? 4: What should you do immediately following a Run Statistics or a Reorganize Table operation? Exercise Create several event monitors and snapshot monitors for your database. Change the performance variables to make it easier to exceed the thresholds. Perform several actions on the database to cause the thresholds to be exceeded. Look at the graphs and data provided. Create an access plan graph, and then perform a Run Statistics and Reorganize Table operation on the table you're querying and re-create the access plan graph. Did any of the values change? Create an access plan graph and determine whether an index is used when accessing the data. Create several indexes on the table and rerun the access plan graph to see whether any of the new indexes are used.

[ Team LiB ]