Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> "equal" Vs. "Like"

"equal" Vs. "Like"

From: Eddie <edawad_at_hotmail.com>
Date: Fri, 22 Sep 2000 22:10:52 GMT
Message-ID: <MNQy5.2042$bm4.219103@paloalto-snr1.gtei.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US