Re: Which is faster? <> or Between

Pablo Sanchez wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in
> 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.
>
> That's all good in theory, however that's not the reality of what can
> and does happen. It's about time Oracle started _not_ requiring a
> table for EXPLAIN PLAN.
> --
> Pablo Sanchez, Blueoak Database Engineering
> http://www.blueoakdb.com

Patently ridiculous. What does the table have to do with anything?

Surely you don't believe it is an imposition for a DBA to create one table
and then GRANT privileges on it to specific users.

Perhaps I am misjudging but this seems to come from the "I want to get paid for doing nothing" camp.

--
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)