Re: Which is better?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 31 Jan 2006 15:24:57 -0800
Message-ID: <1138749893.962247@jetspin.drizzle.com>

pankaj_wolfhunter_at_yahoo.co.in wrote:
> Greetings,
> Which is better, performance wise. Using "BETWEEN" clause
> or using "<=" or ">=" clause.
> Just wanted to know performance significance,if any.
>
> Any help would be appreciated
>
> TIA
Assuming the answer would be the same for every version of Oracle from 2.3 through 10.2?

If you want to know ... test it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Jan 31 2006 - 17:24:57 CST