Re: Which is faster? <> or Between

From: Isaac Blank <izblank_at_yahoo.com>
Date: Wed, 02 Jul 2003 19:46:11 GMT
Message-ID: <7EGMa.242$QJ.194@newssvr16.news.prodigy.com>

"Pablo Sanchez" <honeypot_at_blueoakdb.com> wrote in message news:Xns93AC927472945pingottpingottbah_at_130.133.1.4...
>
> This is often attributable to cost issues in that 'managment' doesn't
> want to spend $'s to have exact replicas of production boxes.

We do have a stress test database which resembles the production pretty closely. The problem is, it is hard to synchronize it with production due to security concerns. Each time we release a new version of the stress test database, we have to protect everything that can possibly violate customers' privacy and at the same time keep data distribution similar to production, and that takes time and effort, too.
>...........................................................................

...................So

> where were we with CREATE TABLE and EXPLAIN PLAN's? Ah yes, let's get
> rid of that dependency. <g>

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. Received on Wed Jul 02 2003 - 14:46:11 CDT