Re: SQL Execution Query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 12 Aug 1998 21:45:14 +0200
Message-ID: <35D1F0C9.98D48858@sybrandb.demon.nl>

You should always write between if you have a choice between '01-jan-98' and '31-dec-98' is always more efficient than
> '01-jan-98' and < etc as precedence rules may tear the two halves of
the former between apart. A between will usually result in an index range scan, hopefully (if the column is indexed of course)

Hth
Sybrand Bakker, Oracle DBA

Manash Chakraborty wrote:

> what are the pursing technique of
> AND, OR, BETWEEN,
>
> how shall I arrange them according to their efficiency ?
>
> any help will be highly appreciated.
>
> Tapash(c.tapash_at_usa.net)
Received on Wed Aug 12 1998 - 14:45:14 CDT