Requires Free Membership to View

Most of the decisions about SQL processing can and should be left to Oracle's Cost-Based Optimizer. Make sure that you have accurate statistics on your tables and indexes so that the optimizer has the information it needs to do its job.
When you are ready to tackle the tuning of individual SQL statements, you
will want to use the EXPLAIN PLAN command to see the optimizer plan for a
given query, the DBMS_SUPPORT package to trace Oracle sessions, and the
TKPROF utility to format trace information. The Oracle documentation
contains information on all of these.
This was first published in May 2004
Join the conversationComment
Share
Comments
Results
Contribute to the conversation