Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tracing makes the sql run faster

Re: tracing makes the sql run faster

From: Ryan <ryan_gaffuri_at_comcast.net>
Date: Mon, 1 Nov 2004 22:50:39 -0500
Message-ID: <004801c4c08f$21c9dbf0$350a5444@ryannew>

do an explain plan on the query.

then look at the plan in the trace file.

dunno at this point. You have to see why its faster.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 01 2004 - 21:46:36 CST

This message: [ Message body ]
Next message: Ravi B: "More processors and Memory added to the server. What config changes are required"
Previous message: Alex: "Re: disabling a role via a logon trigger"
In reply to: Prasada.Gunda_at_hartfordlife.com: "Re: tracing makes the sql run faster"
Next in thread: Prasada.Gunda_at_hartfordlife.com: "Re: tracing makes the sql run faster"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US