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
