Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Most efficient datatype for keys???
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