Re: Which is faster? <> or Between

"Isaac Blank" <izblank_at_yahoo.com> wrote in news:7EGMa.242$QJ.194_at_newssvr16.news.prodigy.com:

> The problem is, it is hard to synchronize it with
> production due to security concerns.

Bingo! That's why generalized statements like some posters are prone to make are easy to kick back down. There are always issues at sites that need to be addressed. The reality is that business is what makes the world spin, not technology. Whether we (as technologist) like this or not, that's the way it is.

> I think the table should be created automatically whenever a new
> login is created, with all the necessary privileges. It is actually
> nice to have some persistency.

What I'm thinking is that Oracle Engineering redo the whole EXPLAIN PLAN method such that a perm temp table isn't needed. End of problem.

But then what would we bicker about? <G>

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