Re: Which is faster? <> or Between

From: Isaac Blank <izblank_at_yahoo.com>
Date: Tue, 01 Jul 2003 00:57:56 GMT
Message-ID: <o05Ma.206$Z04.31531036@newssvr21.news.prodigy.com>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F00CE4C.E10A09DE_at_exxesolutions.com...

> Fine. But the concept here is one of moving code from Development to Test
to
> Production.
>
> When it is in production it belongs to the production DBAs, not the
developers
> or the testers.

When there is a performance problem in production, DBAs can only detect it. It is very seldom that they can fix it - usually when they themselves screwed it up by dropping an index or messing up statistics, etc. So they will turn to the developer on call for diagnostics and resolution.

> If a production DBA can't manage a production database with respect to
explain
> plan they
> certainly can't handle the more onerous task of setting up security, sga,
etc.

Agreed. Like you have said in a previous posting, everyone can run explain plan :-) Received on Mon Jun 30 2003 - 19:57:56 CDT