Re: Do you ever have days where you dont want to think ?

Stephane,

I *did* warn you about the OT list before I approved your registration on it......

btw, this sounds like it should have gone private, not to the list

Rachel

|--------+----------------------->


|        |                       |

|        |                       |

|        |          sfaroult_at_orio|

|        |          le.com       |

|        |                       |

|        |          05/18/2002   |

|        |          11:13 AM     |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >----------------------------------------------------|
  |                                                    |
  |       To:     ORACLE-L_at_fatcity.com                 |
  |       cc:     (bcc: Rachel Carmichael)             |
  |       Subject:     Re: Do you ever have days where |
  |       you dont want to think ?                     |
  >----------------------------------------------------|

Larry Elkins wrote:

>
> The beach part sounds great, though I don't care to see naked men running
> around ;-)

 That's the problem in this job. Too many men. And among women, too many are like honorary men.

Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet.
I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there.

Cheers,

Stephane Faroult

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rachel_Carmichael_at_Sonymusic.com

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