hrs Specialised Oracle Training to meet your needs

Home Up The Team Customised Consultancy

Tuning

Oracle SQL Tuning

Assumptions and pre-requisites

Delegates should have used SQL with some relational database, such as Oracle, SQL Server or Access

Course Outline

About Indexes

  • Why build indexes?
  • The basic balanced B-Tree index
  • The "Index Only Table"
  • Special index types
    • Function based
    • Reverse
    • Binary

Are our indexes being used and is it faster?

  • Using Explain Plan
  • Using SQL*Trace and TKPROF
  • Using AUTOTRACE

How the Oracle Parser Works

  • Sharing SQL
  • Bind variables
  • Identifying "critical" SQL
  • Using the Oracle Enterprise Manager
  • Cost-based optimiser

An overview of STATSPACK

Using temporary tables

Using Materialised Views

Reorganisation with EXPORT/IMPORT

Improving data load times

  • Using PL/SQL to perform bulk loads
  • Using SQL*Loader
[RETURN TO LIST OF COURSES]

 

[Home] 

Send mail to pleasering@oracle-training.co.uk with questions or comments about this web site.
Copyright © 2003 hrs
Last modified: February 11, 2003