Tim

I've realized that SQL with between is more optimized than >= and <= dates.
Am I right ?

Examples:
select * from table where dat >= '2006-01-01' and dat <= '2006-01-31'
and
select * from table where dat between '2006-01-01' and '2006-01-31'

Eduardo

Eduardo,

<< I've realized that SQL with between is more optimized than >= and <=
dates.  Am I right ? >>

Yes.  BETWEEN can do the index scan in one shot, whereas the ANDed version
requires two index scans.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Ok, I stayed happy with you answer.

Thanks

Eduardo