Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's the most efficient primary key ?
worldonline wrote in message <9elo7s$sf2$1_at_nereid.worldonline.nl>...
>I want to create billions of unique key, wat's the best option?
>
>a compound key containing several integer-columns,
>a large datatype (decimal)
>or a string perhaps ??
>
>i would like the first options, it is good for using OID's
>
>
And since this is cross-posted to a suspiciously large number of servers,
PLEASE EVERYBODY ON ALL GROUPS, restrain yourselves from slagging off,
finger-pointing, and "we're better" type messages!
We've only just got over the "Re: Good News for MS Windows users: Your favorite database is here.." trollbait.
-- "Dis act ain't about lafter - it's about comedy" - Andrew Dice ClayReceived on Sun May 27 2001 - 20:09:55 CDT