Re: What's the most efficient primary key ?

From: Obnoxio The Clown <obnoxio_at_hotmail.com>
Date: Fri, 25 May 2001 16:24:27 +0100
Message-ID: <990804492.81920982@news.cis.dfn.de>

On Fri, 25 May 2001, worldonline wrote:
>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

Um. Any particular reason this was cross posted across the entire known universe?

I you were using Informix IDS 9.2, you could use a SERIAL8, which is an 8-byte, autoincrementing integer. They're probably in descending order of efficiency as listed, although it might vary on implementation. Received on Fri May 25 2001 - 10:24:27 CDT