Re: Which is faster? <> or Between

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Wed, 02 Jul 2003 02:23:38 GMT
Message-ID: <3F0246B0.9070803@adelphia.net>

Isaac Blank wrote:
> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F0097B2.F3CEDF47_at_exxesolutions.com...
[]

>>
>>You don't. On a production machine you shouldn't have developers doing
>>anything.
>>
>>The DBA should create the table. The dba should run explain plan.
>>And if the DBA can't you should get a DBA that can.
>>


> 

>     I agree that it's a DBA's job to create the table and grant the

> privileges. But normally I have to run explain plan several times trying
> to find the best version of the query. And quite often it involves more
> than just creating another index or re-writing the query to an equivalent
> form. Quite often I have to know the application and the data to be able to
> solve the performance issue. Having a DBA sit besides me all the times I
> need to run explain plan would be wasting his/her time.
>
>

Why? If it solves the production issue, where's the time wasted??

And yes, I have had to bring in a DBA to assist in some problems. Very rarely, but it has happened. I do not think we wasted time and neither did the company/managers we worked for.

Otherwise, I'm my own debugger/performance tuner in development and testing (unit). If I do not have the privileges to run at least EXPLAIN PLAN, then I'm talking to my manager who communicates to the DBA's manager who talks to the DBA that grants me the tools I need to get the work done.

Do you really try to develop with one hand tied behind your back?

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Tue Jul 01 2003 - 21:23:38 CDT