This course will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database. This course will help you understand the process of SQL as it is executed in an Oracle Database. You learn to write well tuned SQL statements and utilize tools, such as cost-based optimizer, to execute a more efficient SQL process within an Oracle Database.

Skills Gained

• Interpret execution plans and the different ways in which data can be accessed.
• Decipher, decide and then apply tuning to SQL code.
• Use various tuning techniques.
• Take advantage of bind variables, trace files and use the different types of indexes.
• Use different access paths for better optimization.