Course Details

Previous Page


Oracle Database 11g: Indexes, Access Paths, and Join Operations


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range, full, fast full, skip, and index join index scans, as well as bitmap indexes and combining bitmap indexes. Additionally, this course discusses B*-tree, bitmap, composite, and invisible indexes and nullable columns when using indexes. Bitmap operations, guidelines for managing indexes, index usage, clusters, sorting operators, join methods, and other n-array operations are also covered.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: Indexes, Access Paths, and Join Operations

  • identify the functions of table scans in the optimizer
  • recognize types of indexes and how index scans work
  • recognize the features of index-organized tables and bitmap and composite indexes
  • use different acces paths
  • recognize how clusters and sorting operators work
  • recognize how joins and N-array operations work
  • recognize how to cache query results in the SGA
  • Course Number:
    od_ortw_a02_dt_enus