Interview Question
Business Data Intelligence Developer Interview
-Reno, NV
Universal Health Services, Inc.What is a clustered/non clustered index.
AnswerAdd Tags
Interview Answers
2 Answers
▲
0
▼
I explained how a clustered index was in sequential physical order on disk and a non clustered index used pointers or a hash table for index lookup. I started to explain the advantages/disadvantages of each index type but the two guys interviewing me just seemed so confused and lost. I think I would have been better of simply saying "it makes lookup faster".
Anonymous on
▲
0
▼
I explained how a clustered index was in sequential physical order on disk and a non clustered index used pointers or a hash table for index lookup. I started to explain the advantages/disadvantages of each index type and how I would use them.
Anonymous on
Add Answers or Comments
To comment on this, Sign In or Sign Up.