Re: How to speed up my SQL commands?

You're best bet is to use TKPROF which is better than just a explain plan. It will show how many rows you are returning for each step.

Under SQL*PLUS, just do an ALTER SESSION SET SQL_TRACE=TRUE;

Run your select, exit and go to where the trace file is at and then do:

tkprof <trace filename> <output filename> explain=userid/password

In comp.databases.oracle.tools Manuel Dias <manueld_at_burotica.pt> wrote:
: I have performance problems with my SQL statments in my Oracle 8.1.5 db.
: Does any body knows where can I find the ORACLE SQL ANALYSE
: tool (or similar) to help me improve my SQL statments?

: Thank you!
: Manuel Dias

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Ivan Samuelson                 * 
Staff Support Coordinator and  * isamuels_at_columbus.rr.com
Information Systems Consultant *
Metro Information Services     * http://home.columbus.rr.com/isamuels
http://www.MetroIS.com         *
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-