Best performing data type for GUID

From: Susan White <>
Date: Mon, 7 Jul 2008 08:49:52 -0500
Message-ID: <4DDBA919D6EDE44B8868846F987146E5CA3547@ltivw-p-ml01.LIFETOUCH.NET>

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.  



This email has been scanned by the MessageLabs Email Security System. For more information please visit
Received on Mon Jul 07 2008 - 08:49:52 CDT

Original text of this message