Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NUMBER versa CHAR as a primary key ?
Maybe you have a point but I can't fully understand you.
Numbers are generally easier to compare than characters. This is not an Oracle-specific rule. It's true to all kinds of computers. If everything else is the same, use numbers rather than strings (CHAR or VARCHAR2) as your primary key.
Yong Huang
Peter Chong <pchq45_at_nospam.hotmail.net> wrote in message
news:eCPf5.9143$qM3.56653_at_news1.bnapk1.occa.home.com...
> In General, In Most DB from the beginning, Value Inside of CHAR is more
> fragment than Number
> Some how hashing routine is work better for not contiguous number in value
> like CHAR.
> Peter C.
> Janusz Gryczman <janusz_at_winternet.com> wrote in message
> news:397FBC29.A6A5CEE0_at_winternet.com...
> > Is it true, that using NUMBER Oracle type versa CHAR for a primary key
> > improves performance ?
> > If yes what is the ratio ? Is it really significant ?
> > What about if primary key has a type VARCHAR ?
> > Really appreciate answer to this question.
> >
>
>
Received on Thu Jul 27 2000 - 00:00:00 CDT