Re: ESCAPE clause causing longer query execution time

Please show the SQL statements in question.

There's not much point in speculating on what you
*may* be doing.


On Fri, 18 Feb 2005 14:40:46 -0500, traci.l.rebman@xxxxxxx
<traci.l.rebman@xxxxxxx> wrote:
> Hello,
> I have a query using LIKE with the ESCAPE clause to search for an
> underscore '_' as a literal value.  When I run the query with the ESCAPE
> clause it takes much longer then when the same query is run without the
> ESCAPE clause.  I thought maybe it was an index issue, but explain plans
...
-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Other related posts: