Re: ESCAPE clause causing longer query execution time

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: traci.l.rebman@xxxxxxx
  • Date: Mon, 21 Feb 2005 09:58:45 -0800

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

Other related posts: