Re: Which is faster? <> or Between

"Isaac Blank" <izblank_at_yahoo.com> wrote in news:C_DMa.187$NU2.94_at_newssvr16.news.prodigy.com:

> True, but execution plans in development and test environments often
> differ from production - different table sizes, different data
> distribution.

This is often attributable to cost issues in that 'managment' doesn't want to spend $'s to have exact replicas of production boxes. So where were we with CREATE TABLE and EXPLAIN PLAN's? Ah yes, let's get rid of that dependency. <g>

-- 
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com