Re: "equal" Vs. "Like"

Equals is faster as it does not do a pattern search

Eddie wrote:

> Hi,
> Which is faster:
>
> Select column_name1
> from table_name
> where column_name2 like 'Y%'
>
> or
>
> Select column_name1
> from table_name
> where column_name2 = 'Y'
>
> knowing that column_name2 is VARCHAR2(1) and contains either 'Y' or 'N'
>
> Thank you for your help,
>
> Eddie.
Received on Mon Oct 02 2000 - 14:54:18 CDT