Základní info
The SQL Tuning Workshop covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.earn to:dentify Poorly Performing SQL nderstand the Query Optimizer race applications onitor SQL execution in real time nterpret execution plans