Oracle SQL tuning for developers and DBA’s

22 Jan 2018
17:00 - 17:45

Oracle SQL tuning for developers and DBA’s

This lecture will focus on providing important guidelines, recommendations and best practices for writing efficient and optimized SQL statements while ensuring high level of performance and response time. We will explore how to write well-tuned SQL statements and see some different ways in which the Oracle optimizer can access data in tables and indexes, rewriting complex sub-queries, using the WITH clause and scalar sub-queries, using EXISTS, using new caching features, implementing new optimizer statistics features, interpreting execution plans, taking advantage of bind variables, using hints.