Oracle SQL Performance Tuning

PPi Learning Services

Course

In London

£ 725 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

By the end of the course, the delegate will be able to tune applications for optimal performance, optimize SQL queries for faster access and tune code to reduce disk I/O and reduce network traffic.

Facilities

Location

Start date

London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course content
  • Tuning Database Applications for Optimal Performance
  • Managing Statistics
  • Creating and Using Indexes
  • Creating and Using Views
  • StructuringSQLStatements for Performance
  • Using theSQLOptimizers
  • Examining the Execution Plan of aSQLStatement usingEXPLAINPLAN
  • Examining the Efficiency ofSQLStatements usingSQLTrace and Autotrace
  • Using Hints to Influence Execution Plan
  • Identifying Unused Indexes
  • PL/SQL Tuning Issues

See related categories

Oracle SQL Performance Tuning

£ 725 + VAT

The best Oracle courses

See all

See all