EQUAL vs LIKE

From: Eddie <edawad_at_hotmail.com>
Date: Fri, 22 Sep 2000 22:12:07 GMT
Message-ID: <XOQy5.2047$bm4.219555_at_paloalto-snr1.gtei.net>


Hi,
Which is faster:

Select column_name1
  from table_name
[Quoted] 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 Sat Sep 23 2000 - 00:12:07 CEST

Original text of this message