SQL Tuning

SQL Tuning

English | 2015 | MP4 | AVC 1376×768 | AAC 44KHz 2ch | 3 Hours | 648 MB

Learn how to formulate and tune SQL statements for optimal performance

This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems and will provide you with the skills necessary to write scalable, high performance SQL.

The SQL tuning methodology I used:

  • Identify a problem SQL statement
  • Determine how Oracle is executing SQL statement and why Oracle chose that way.
  • Investigate whether alternative executon plans would be better.
  • Update the SQL statement to push Oracle towards the better plan.