Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to store GUIDs generated from Microsoft
> 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 Tue Mar 30 2004 - 12:11:53 CST