⢠Trace an application through its different levels of the application architecture
⢠Understand how the Query Optimizer makes decisions about how to access data
⢠Define how optimizer statistics affect the performance of SQL
⢠List the possible methods of accessing data, including different join methods
⢠Identify poorly performing SQL
⢠Modify a SQL statement to perform at its best
