GUID generation and storage
bobmaganApr 24 2013 — edited Apr 24 2013I am on 11.2 DB. I am looking for a way to store a GUID in my tables (set as PK or Unique Index) that would be unique across multiple databases that run my app. I have investigated using the sys_guid() which I think is unique but is more expensive (in storage and calculation) than a sequence generator. My investigation tested storing the sys_guid as a varchar2(32) field, and I noticed that it seemed to slow on the index creation when many rows were inserted. I was wondering if would make much difference if I stored it as a raw(16) instead, or maybe a different approach someone may have. Thanks