Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which is better?

Re: Which is better?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 1 Feb 2006 09:35:28 -0500
Message-ID: <a--dnQb2Te-vWn3eRVn-vQ@comcast.com> 






<pankaj_wolfhunter_at_yahoo.co.in> wrote in message 
news:1138748496.250747.49100_at_g49g2000cwa.googlegroups.com...


> 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


>




run trace on statements with each clause and compare the execution plans



++ mcs 
Received on Wed Feb 01 2006 - 08:35:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US