Oracle Indexes Demystified

Short course

In Gatwick

£ 495 + VAT

Description

  • Type

    Short course

  • Location

    Gatwick

  • Duration

    1 Day

Upon completion of this presentation, the delegate should be able to choose amongst index options so as to optimise processing in OLTP and data warehousing environments. Suitable for: Database administrators, system administrators and performance analysts.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Working knowledge of Oracle architecture, processes and schema objects.

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



Currency:
10g & 11g

Audience:
Database administrators, system administrators and performance analysts.

Prerequisites:
Working knowledge of Oracle architecture, processes and schema objects.

Summary:
This course discusses all of the Oracle index options:

  • B*tree
  • Bitmap
  • Hash
  • Partitioned
  • Index clustered table
  • Etc.

in the following contexts:

  • Structure and organisation
  • How to choose
  • Column selectivity
  • Maintenance
  • Performance
  • Monitoring
  • OLTP vs. data warehousing


Objectives:
Upon completion of this presentation, the delegate should be able to choose amongst index options so as to optimise processing in OLTP and data warehousing environments.

Oracle Indexes Demystified

£ 495 + VAT