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.