Checking the plan

• Try to keep the cost low

• Reduce number of nested loops

• Keep heavy scans high up in the loop hirarchy

• Try to get efficient access paths

• Avoid full table scans on tables holding a large amount of data

Notes: