You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool. You need to create a surrogate key for the table. The solution must provide the fastest query performance. What should you use for the surrogate key?
A. a GUID column
B. a sequence object
C. an IDENTITY column
Discussion forum
Question
Leave an answer