Re: oracle/sql "where clause"
From: <bartavi_at_mail.tlm.openu.ac.il>
Date: 1996/10/01
Message-ID: <DyMH3M.Irx_at_cs.openu.ac.il>#1/1
Date: 1996/10/01
Message-ID: <DyMH3M.Irx_at_cs.openu.ac.il>#1/1
Paul Chow <pschow_at_compusmart.ab.ca> 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-
hi paul,
the optimizer will change the second query into the format of the first one. so you can do it yourself or live it for the optimizer....but the execution time will be the same.
Bartal V. Received on Tue Oct 01 1996 - 00:00:00 CEST