Re: NUMBER versa CHAR as a primary key

Janusz Gryczman wrote:
>
> 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.

I'll think you'll find there is (in measurable terms) no difference...

However, there is often a case for the use of synthetic keys (eg sequence numbers) so that 'keys' can be updated if required...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse