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: ESCAPE clause causing longer query execution time

Re: ESCAPE clause causing longer query execution time

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 22 Feb 2005 07:16:16 -0800
Message-ID: <bf46380502220716d1f0142@mail.gmail.com>


This may be helpful. If the correct information is supplied the first time, it will help you find a solution, or at least an explanation, much sooner.

http://www.catb.org/~esr/faqs/smart-questions.html#beprecise

On Tue, 22 Feb 2005 09:12:13 -0500, Powell, Mark D <mark.powell_at_eds.com> wrote:
> I think displaying the SQL with explain plans for the two versions would be
> helpful. What indexes with columns exist on pf_document_rv? Is the data in
> r_object_id stored as mixed case, upper?
>
> -- Mark D Powell --
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 22 2005 - 10:19:15 CST

Original text of this message

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