Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

This article explores the internals of Oracle9i indexing; reviews the standard b-tree index, index-only tables, and how these indexes may increase the speed of Oracle SQL queries.