Re: Which is faster? <> or Between

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3F02FFB0.6F579E3B_at_remove_spam.peasland.com...
> > All I said was, I do not need DBA sit besides me when I run explain
> > plan. Actually, I do not even run explain plan, I just use tools that
would
> > do that for me when I feel like it.
>
> There is a problem above. All SQL statements should be tuned, even if it
> seems perfectly obvious what the execution plan should be.
>

    True, but execution plans in development and test environments often differ from production - different table sizes, different data distribution. If I see a problem with execution plan in development, it does not necessarily mean a problem in production. I usually double check with the stress test environment, which is closest to production, but for new tables there is no reasonable way out. So all I can do is monitor - and that's where DBAs are really helpful.

>
> Maybe it is a "rare beast" from where you come from, but not in most
> Oracle shops. I'd have to disagree with your statements. In my
> experience, the DBA knows much, much more about query tuning then
> application developers. And I haven't seen DBAs go running off to
> developers for assistance if the "there is a performance issue beyond
> anything obvious like lost index or broken stats." In my experience, it
> is the other way around.
>
> Just my 3.14159265 cents worth,
> Brian
>
>
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Wed Jul 02 2003 - 11:45:22 CDT