Which is faster? <> or Between

#31

Quote:

Using my brain or a calculator to produce an answer in mathematics will not
produce different answers.

So is this to say that your brain can calculate the following:

(ln(pi^1/4))^2/3

just as accurately as a calculator?

Just kidding...
LOL,
Brian

--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

#32

"Isaac Blank" <izblank (AT) yahoo (DOT) com> wrote

Quote:

"Pablo Sanchez" <honeypot (AT) blueoakdb (DOT) com> wrote in message
news:Xns93AC927472945pingottpingottbah (AT) 130 (DOT) 133.1.4...

This is often attributable to cost issues in that 'managment' doesn't
want to spend $'s to have exact replicas of production boxes.
We do have a stress test database which resembles the production
pretty
closely. The problem is, it is hard to synchronize it with production due
to security concerns. Each time we release a new version of the stress
test
database, we have to protect everything that can possibly violate
customers' privacy and at the same time keep data distribution similar to
production, and that takes time and effort, too.

.................................................. .........................
...................So
where were we with CREATE TABLE and EXPLAIN PLAN's? Ah yes, let's get
rid of that dependency. <g

I think the table should be created automatically whenever a new login
is created, with all the necessary privileges. It is actually nice to
have
some persistency.

conn system/<pwd>;
@?/rdbms/admin/utlxplan
create public synonym plan_table for plan_table;
grant all on plan_table to public;

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

#33

"Niall Litchfield" <niall.litchfield (AT) dial (DOT) pipex.com> wrote in
news:3f0494aa$0$10623$cc9e4d1f (AT) news (DOT) dial.pipex.com:

Quote:

"Isaac Blank" <izblank (AT) yahoo (DOT) com> wrote in message
news:7EGMa.242$QJ.194 (AT) newssvr16 (DOT) news.prodigy.com...

conn system/<pwd>;
@?/rdbms/admin/utlxplan
create public synonym plan_table for plan_table;
grant all on plan_table to public;

indeed; one table for all to share! <g>
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com

#34

You've gotta slow these guys down somehow. Errm or ensure that they use
statement_id.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Pablo Sanchez" <honeypot (AT) blueoakdb (DOT) com> wrote

Quote:

"Niall Litchfield" <niall.litchfield (AT) dial (DOT) pipex.com> wrote in
news:3f0494aa$0$10623$cc9e4d1f (AT) news (DOT) dial.pipex.com:

"Isaac Blank" <izblank (AT) yahoo (DOT) com> wrote in message
news:7EGMa.242$QJ.194 (AT) newssvr16 (DOT) news.prodigy.com...

conn system/<pwd>;
@?/rdbms/admin/utlxplan
create public synonym plan_table for plan_table;
grant all on plan_table to public;

indeed; one table for all to share! <g
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com

#35

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote in
news:3f092fe0$0$18489$ed9e5944 (AT) reading (DOT) news.pipex.net:

Quote:

You've gotta slow these guys down somehow. Errm or ensure that they
use statement_id.

<G>
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com

#36

On 30 Jun 2003, pablo (AT) dev-null (DOT) com wrote:

Quote:

Daniel Morgan <damorgan (AT) exxesolutions (DOT) com> wrote in
news:3F006029.ECE34F77 (AT) exxesolutions (DOT) 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.'

Does anybody alter the create table statement for the plan_table to be

create global temporary table PLAN_TABLE (

then create a public synonym to that? Each developer could then run a
non-named plan, then their plan query and then truncate the plan_table,
all without having to have created a table or mess up someone else by
cleaning it out with a truncate.

(Oh well, this is how I do it for development instances, so that nobody
has to continue to recreate their plan_table as their schema gets
cleaned out)

--
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

#37

On Tue, 1 Jul 2003, ray_porter (AT) unc (DOT) edu wrote:

Quote:

in general, developers don't have CREATE TABLE in development, test or
production.

In my company, each developer has a local instance of Oracle for his own
little sandbox. Their database schema is built from CVS checkout and
subsequent ant target.

--
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Which is faster? <> or Between

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Which is faster? <> or Between - 07-03-2003 , 07:54 AM

Re: Which is faster? <> or Between - 07-03-2003 , 03:42 PM

Re: Which is faster? <> or Between - 07-06-2003 , 08:52 PM

Re: Which is faster? <> or Between - 07-07-2003 , 03:31 AM

Re: Which is faster? <> or Between - 07-08-2003 , 08:14 AM

Re: Which is faster? <> or Between - 07-13-2003 , 11:14 PM

Re: Which is faster? <> or Between - 07-13-2003 , 11:23 PM