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:
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-lReceived on Wed Oct 05 2011 - 10:03:14 CDT