Home > IT Answers > DataManagement > Performance impact by using GUID instead of s...
Help

Question

Asked:
Asked By:
Jan 6 2009   6:46 PM GMT
Jzliao   5 pts.

Performance impact by using GUID instead of sequence as primary key


GUID, Data Model Primary Key, Data warehouse

Is there anyone has experience on using GUID as the primary key in the data model of a huge data warehouse? What is the impact of the performance compare with the sequencial surrogate key in Oracle 10g or higher version?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on DataManagement.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register