Best performing data type for GUID

  • From: "Susan White" <swhite@xxxxxxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 7 Jul 2008 08:49:52 -0500

We need to store GUIDs and they will be the primary access point into
very large tables. What is the recommended data type?  I see
varchar2(36) and RAW. Is one better than the other?  Is there another
option? Is there significant performance difference between the options
as this app must scale and we have to squeak out all possible
performance.

 

Thanks,

 

Susan


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

Other related posts:

  • » Best performing data type for GUID