Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


between clause versus and


between clause versus and  using -'sql,performance,oracle,oracle10g,oracle11g'

Is there a performance difference between using a BETWEEN clause or using <= AND >= comparisons?

i.e. these two queries:

SELECT *  
  FROM table  
 WHERE year BETWEEN '2005' AND '2010';  


...and

SELECT *  
  FROM table  
 WHERE year >= '2005' AND year <= '2010';


In this example, the year column is VARCHAR2(4) with an index on it.
    

asked Oct 13, 2015 by yashwantpinge
0 votes
0 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...