Re: Which is faster? <> or Between

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.

Consider the fact that your attitude may work with your current employer ... but won't necessarily with your next.

I, for one, would not tolerate what you indicate. When I pay developers I pay them to do a good job ... not just show up. And others take that same approach. On a project at AT&T Wireless a few years back the policy was that no developer could show up at a code review with his/her code without first sending a copy of the explain plan to every member of the team demonstrating alternative approaches if the cost was high.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)