Re: Which is faster? <> or Between

Pablo Sanchez wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in
> news:3F006029.ECE34F77_at_exxesolutions.com:
>
> > Now if you don't have CREATE TABLE that could be a problem. But if
> > you don't have CREATE TABLE you aren't a developer.
>
> A shame that you have to give a developer CREATE TABLE on a production
> machine to replicate the problem that 'only shows up on a production
> instance.'
> --
> Pablo Sanchez, Blueoak Database Engineering
> http://www.blueoakdb.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.

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