First page Back Continue Last page Graphics

Index Scans

Oracle supports several types of index scans
- Index Unique Scans
- Index Range Scans [Descending]
- Index Skip Scans
- Full Scans
- Fast Full Index Scans
- Index Joins
- Bitmap Conversions

Notes:

An index scan retrieves a ROWID and/or column values from an index. Oracle supports several types of index scans. This section of the course will look at many of the types of index scans available with Oracle9i.