errm and we aren't comparing to a number, but to a RAW column. unless I've
missed the point entirely.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:4069B869.FFD1846D_at_remove_spam.peasland.com...
> > How about the performance when using a string as Primary key - is
there
> > any significant difference compared to using a number?
>
>
> It has been my experience that any performance differences are
> insignificant. One could make a case that a large string will take more
> room to store than a number, therefore limiting the number of entries in
> an index's leaf nodes and this can contribute to a performance
> difference. But this will most likely be inconsequential.
>
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Thu Apr 01 2004 - 14:35:29 CST
