Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql running slow when run from java but runs fine when run from toad

Re: sql running slow when run from java but runs fine when run from toad

From: picksdba <Utpal.Dhar_at_gmail.com>
Date: 5 May 2006 08:58:43 -0700
Message-ID: <1146844723.235685.211910@i39g2000cwa.googlegroups.com>


I did try to use the hint, but it is still the same. I do not know how to implement Plan Stability.
But i do not understand why it is using INDEX SKIP SCAN, because i am using all the composite columns of the primary key Received on Fri May 05 2006 - 10:58:43 CDT

Original text of this message

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