Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which is faster? <> or Between

Re: Which is faster? <> or Between

From: Pablo Sanchez <honeypot_at_blueoakdb.com>
Date: 30 Jun 2003 22:01:49 GMT
Message-ID: <Xns93AAB7695E4D4pingottpingottbah@130.133.1.4>


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
Received on Mon Jun 30 2003 - 17:01:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US