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_at_rrd.com <traci.l.rebman_at_rrd.com> 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