Re: What does LIKE '%%' actually do in a WHERE clause?

From: Paul G Parker <parkerpg_at_gmail.com>
Date: Wed, 5 Oct 2011 11:03:14 -0400
Message-ID: <CANS6Wbr=YUwh6Mpx0YNqaxECo6rCT7v=eConQdaq67+Bz+ugxg_at_mail.gmail.com>



Seems like the cardinality drops to 5% when using '%%' as opposed to '%' - so must be an optimizer anomaly.
On Wed, Oct 5, 2011 at 10:27, Dunbar, Norman (Capgemini) < norman.dunbar.capgemini_at_environment-agency.gov.uk> wrote:

> Afternoon all,
>
> a developer is asking me what the exact function of "LIKE '%%'" in a WHERE
> clause is. I'm stumped, and cannot find anything on Google or in the Oracle
> docs.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 05 2011 - 10:03:14 CDT

Original text of this message