asked on clustered index and composite index
hi
can i have a table with both a clusterd index (companyid column) and also a composite index (companyid column and userid column)
just wondered if you could have both and using the same column?
Cheers
can i have a table with both a clusterd index (companyid column) and also a composite index (companyid column and userid column)
just wondered if you could have both and using the same column?
Cheers
Microsoft SQL Server
Last Comment
ac_davis2002
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks chaps