Home > IT Answers > Business Intelligence > Performance impact by using GUID instead of sequence as primary key
Jzliao
5 pts.
 Performance impact by using GUID instead of sequence as primary key
Data Model Primary Key, Data warehouse, GUID
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?

Software/Hardware used:
ASKED: January 6, 2009  6:46 PM
UPDATED: January 6, 2009  6:51 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _