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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Most efficient datatype for keys???

Re: Most efficient datatype for keys???

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/14
Message-ID: <5ir7gf$lhu$5@tst.hk.super.net>#1/1

Z. Martinez wrote:
>
> I'm trying to determine the fastest datatype for a key?
> I will be using it as a primary key for a very large table.
>
> I'm currently using a number(10).
> Is there a more efficient datatype I can use for this purpose.

I don't think it will make major difference if you use correctly. But normally, number is more easy to implement and smaller storage. It can't imagine why number can be slower, so why not number ?? Received on Mon Apr 14 1997 - 00:00:00 CDT

Original text of this message

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