Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Which is faster: Like or = ?
Hi,
Which is faster:
Select column_name1
from table_name
where columnn_name2 like 'Y%'
or
Select column_name1
from table_name
where columnn_name2 = 'Y'
knowing that columnn_name2 is VARCHAR2(1) and contains either 'Y' or 'N'
Thank you for your help,
Eddie. Received on Fri Sep 22 2000 - 14:52:59 CDT