Re: oracle/sql "where clause"
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1996/09/26
Message-ID: <324A1334.682_at_charlie.cns.iit.edu>#1/1
Date: 1996/09/26
Message-ID: <324A1334.682_at_charlie.cns.iit.edu>#1/1
Paul Chow wrote:
>
> 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-
Second query is efficient than the first one. But make there are no NULL value for that field when using IN operator.
AMARENDRA B NETTEM
WHITTMAN-HART CORPORATION
CHICAGO.
Received on Thu Sep 26 1996 - 00:00:00 CEST