Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> "equal" Vs. "Like"
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 Fri Sep 22 2000 - 17:10:52 CDT
![]() |
![]() |