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

Home -> Community -> Usenet -> c.d.o.tools -> Which is faster: Like or = ?

Which is faster: Like or = ?

From: Eddie <edawad_at_hotmail.com>
Date: Fri, 22 Sep 2000 19:52:59 GMT
Message-ID: <vMOy5.3238$TT.165567@dfiatx1-snr1.gtei.net>

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

Original text of this message

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