What is a clustered/non clustered index.

Question

Sigiloso · Accepted Answer

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".

Sigiloso · Answer

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.

Universal Health Services, Inc.

Pergunta de entrevista da empresa Universal Health Services, Inc.

Respostas da entrevista

Empresas seguidas

Buscas de vagas