Oracle optimizer

• The SQL scripts are manipulated within Oracle prior to execution to enhance performance

• Default optimizer is Cost Based Optimiser CBO

• CBO depends on statistics generated on the installation

• Excecution plans may vary as new statistics recommends other plans

• Other databases may have other ways of optimizing

Notes: