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>
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