Oracle Database 10g SQL (Osborne ORACLE Press Series)

In this chapter, you learned that

• Tuning is the process of making your SQL statements run faster.

• There are a number of tips you can use to tune your SQL statements.

• The optimizer is a subsystem of the Oracle database software that generates an execution plan.

• An execution plan is a set of operations used to perform a particular SQL statement.

• Hints may be passed to the optimizer to influence the generated execution plan.

• There are a number of additional software tools you can use to tune SQL statements. One tool is the Statspack package, which is a set of SQL, PL/SQL, and SQL*Plus scripts that allow you to collect and view performance data.

Apart from the final appendix, that s the end of this book. I hope you ve found the book informative and useful, and I hope I ve held your interest! As you ve seen, SQL is a very large subject. But armed with this book, I have every confidence you will master the subject.