AN INTRODUCTION TO ORACLE SQL STATEMENT TUNING
Bill Magee
21st Feb 2003

You can skip the first three sections of rambling burp and get straight to the nitty gritty at "The basic forms of Oracle data retrieval".