Perfomance-wise, is it the same to query a table on a non-unique GUID in these two cases?
Case 1: Primary key on multiple columns while the significant column is the first item in the primary key
CREATE TABLE xyz (
a uniqueidentifier NOT NULL,
b uniqueidentifier NOT NULL,
c uniqueidentifier NOT NULL,
CONSTRAINT [PK_xyz] PRIMARY KEY (a, b, c) CLUSTERED
)
Case 2: Clustered non-unique index on the column I will use the most to query the table
CREATE TABLE xyz (
a uniqueidentifier NOT NULL INDEX IX_xyz_a CLUSTERED,
b uniqueidentifier NOT NULL,
c uniqueidentifier NOT NULL,
CONSTRAINT [PK_xyz] PRIMARY KEY (a, b, c)
)
Most of the time my table would be queries as SELECT ... FROM xyz WHERE a = ...