Oracle SQL Tuning: Step 3 - Review Implementation plans
* The type of join should be appropriate to the number of rows to process
guide * The table is the best filter is
* Must be derived by next step the smallest number of rows
* The views must be used efficiently
* Examine the where clause from the rows processed at each table
* A Full Table Scan does not imply inefficiency
* Each table must be accessed efficiently
* should not Cartesian products exist that have not been made on purpose