Re: Which is faster? <> or Between

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F02FB0C.6FE3432C_at_exxesolutions.com...
> Isaac Blank wrote:
>
> > "Ed Prochak" <edprochak_at_adelphia.net> wrote in message
> > news:3F0246B0.9070803_at_adelphia.net...
> > > Isaac Blank wrote:
> > > > 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??
> >
> > 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.
>
> If your management tolerates this ... so be it. But in many environments
you
> would be rapidly on your way to unemployment if you (A) didn't explain
plan
> every SQL statement you wrote and (B) used a GUI tool to do what you are
> supposed to be using your brain to do.

    Using a GUI tool to examine query plan is, in fact, a good thing - much easier to figure out the sequence of events and use my brain to do more important things. Maybe your managements prohibits use of calculators - after all, you can use your brain and a piece of paper instead - my management believes that proper tools enhance productivity and improve quality. Received on Wed Jul 02 2003 - 11:18:16 CDT