Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: merging small tables
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