Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to store GUIDs generated from Microsoft

Re: How to store GUIDs generated from Microsoft

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 30 Mar 2004 18:11:53 GMT
Message-ID: <4069B869.FFD1846D@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 Tue Mar 30 2004 - 12:11:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US