Re: Which is better?

#1

pankaj_wolfhunter (AT) yahoo (DOT) co.in wrote:

Quote:

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@x.washington.edu
(replace x with u to respond)

#2

Thanks for the reply. Can i use "set timing on" to see which query is
performing well.
I mean some says that one should not be too dependent on the "set
timing" results.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Which is better?

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Which is better? - 01-31-2006 , 05:24 PM

Re: Which is better? - 01-31-2006 , 05:34 PM