magasvs (7/24/2010)
It would be confusing to get this question on interview, is it? I wouldn't know what is the right answer, probably would give two answers 🙂
I would consider it as an excellent occasion to show off my knowledge of all the various indexes SQL Server uses. I'd probably talk for at least five minutes, cover most (but not all - I'm bound to forget some) index types, never really answer the actual question but still show how much I know about the subject.