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: What's the most efficient primary key ?

Re: What's the most efficient primary key ?

From: Andrew Hamm <NOahammSPAN_at_sanderson.net.au>
Date: Mon, 28 May 2001 11:09:55 +1000
Message-ID: <9es8iv$s3pf$1@ID-79573.news.dfncis.de>

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 Clay
Received on Sun May 27 2001 - 20:09:55 CDT

Original text of this message

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