Message-Id: <10574.113317@fatcity.com> From: Alex Hillman Date: Sun, 30 Jul 2000 13:23:41 -0400 Subject: RE: Why does a simple delete takes 12 hours and longer ? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFFA4A.EBA76EE0 Content-Type: text/plain; charset="iso-8859-1" I think first you need to know the product ( Oracle in this case ) and then make a judgement about quality of it. Alex Hillman -----Original Message----- From: Andreas Jung [mailto:ajung@sz-sb.de] Sent: Friday, July 28, 2000 3:01 PM To: Multiple recipients of list ORACLE-L Subject: Re: Why does a simple delete takes 12 hours and longer ? On Fri, Jul 28, 2000 at 09:39:29AM -0800, Lyall Barbour wrote: > Well, if everything was initialized in the beginning as far as the init.ora > file goes, you're probably doing a Nested Loop anti-join. I'd suggest > inserting ALWAYS_ANTI_JOIN=HASH (or MERGE) > > Just a little tip from your Uncle Lyall! > > Of course to do this.... do you need a bounce, or can you do ALTER > SESSION.... I think you can do alter session. I know you can use a hint in > your delete /*+ HASH_AJ */ *sigh* Oracle is a beast and CBO should be renamed to "Confusing Bastard Optimizer" Andreas -- Author: Andreas Jung INET: ajung@sz-sb.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01BFFA4A.EBA76EE0 Content-Type: text/html; charset="iso-8859-1" RE: Why does a simple delete takes 12 hours and longer ?

I think first you need to know the product ( Oracle in this case ) and then make a judgement about quality of it.

Alex Hillman

-----Original Message-----
From: Andreas Jung [mailto:ajung@sz-sb.de]
Sent: Friday, July 28, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Why does a simple delete takes 12 hours and longer ?


On Fri, Jul 28, 2000 at 09:39:29AM -0800, Lyall Barbour wrote:
> Well, if everything was initialized in the beginning as far as the init.ora
> file goes, you're probably doing a Nested Loop anti-join.  I'd suggest
> inserting ALWAYS_ANTI_JOIN=HASH (or MERGE)
>
> Just a little tip from your Uncle Lyall!
>
> Of course to do this.... do you need a bounce, or can you do ALTER
> SESSION....  I think you can do alter session.  I know you can use a hint in
> your delete /*+ HASH_AJ */

*sigh* Oracle is a beast and CBO should be renamed to
"Confusing Bastard Optimizer"

Andreas
--
Author: Andreas Jung
  INET: ajung@sz-sb.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).