Re: Oracle/SQL Question
Date: 1998/04/20
Message-ID: <6hg75b$sb1$1_at_brokaw.wa.com>#1/1
Check in your documentation about the 'EXPLAIN PLAN' command. This will allow you to see the path chosen by the optimizaer without actually running the query. This tool is free and already exists on your system.
-Pat Ryan
pat_at_halcyon.com
Lorrie (lorrie_at_macconnect.com) wrote:
: I am an Oracle developer. When I am developing SQL statements and tuning
: them, I need to run them over and over again, to see the performance effect
: of changes to the statement, and optimization mode. I also need to see how
: long it takes each statement to run. Also, sometimes when I drastically
: change
: the statement, and it uses the wrong index, the statement goes on for ever.
: Then I have to kill the application, and then ask my DBA to kill the orphan
: client session. Are there any tools out there that could help me with any
: of these problems/requirements?
:
: TIA,
: Lorrie
Received on Mon Apr 20 1998 - 00:00:00 CEST