Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ESCAPE clause causing longer query execution time
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-lReceived on Tue Feb 22 2005 - 10:19:15 CST
![]() |
![]() |