The foundation tools for SQL tuning are:.Make sure your developers understand EXPLAIN PLAN and tkprof, or equip them with commercial tuning tools.Make sure you establish a reasonable sub-set of production data that is used during development and tuning of SQL.

A significant portion of SQL that performs poorly in production was originally crafted against empty or nearly empty tables.Hint #2: Establish a tuning and development environment

Consider de-normalization and other performance by design features early on.

Consider prototyping critical portions of the applications.

Measure performance as early as possible.

Test the SQL for these transactions against simulations of production data.

Explicitly identify performance targets.

Hint #1: Design and develop with performance in mind

Take advantage of Cost Based Optimizer.

Design and develop with performance in mind.

Top tips for Oracle SQL tuning BUY GUY’S BOOK BUY QUEST PRODUCTS BUY QUEST PRODUCTS Guy Harrison Senior Software Architect, Quest Software

Quest sql optimizer for oracle