oracle/sql "where clause"

From: Paul Chow <pschow_at_compusmart.ab.ca>
Date: 1996/09/26
Message-ID: <324a091a.0_at_ntnews.compusmart.ab.ca>#1/1

howdy.

does anyone know whether one of the following two where clauses is more efficient than the other ...

[1]. select ...

      from ...
      where (field_x='K' or field_x='L' or field_x='M')



[2].  select ...


      from ...
      where field_x in ('K','L','M')

thanks for any help.

-paul- Received on Thu Sep 26 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: AMARENDRA B NETTEM: "Re: oracle/sql "where clause""
Previous message: bartavi_at_mail.tlm.openu.ac.il: "Re: [Q]: What are these AAAnnnnnn.TMP files??"
Next in thread: AMARENDRA B NETTEM: "Re: oracle/sql "where clause""
Reply: AMARENDRA B NETTEM: "Re: oracle/sql "where clause""
Reply: Jim Smith: "Re: oracle/sql "where clause""
Maybe reply: John Verhoeven: "Re: oracle/sql "where clause""

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message