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

Home -> Community -> Usenet -> c.d.o.server -> Re: merging small tables

Re: merging small tables

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 9 Aug 2002 14:05:09 -0500
Message-ID: <uu1m34r92.fsf@hotpop.com>


On Thu, 08 Aug 2002, Martin.Haltmayer_at_d2mail.de wrote:

> you may improve your idea by using sequences that start at different
> values and hop in intervals > 1. E. g., sequence 1 starts at 1 and
> hops by 100 each time it is selected from. Sequence 2 starts at 2 and
> also hops by 100 etc. We implemented this as a simple but very
> efficient type and sanity checker.

Not sure how it improves the idea. I guess you have less contention for the index? What if you have > 100 type tables?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Fri Aug 09 2002 - 14:05:09 CDT

Original text of this message

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