NexGenSm interview question

Regarding datbase performance and indexing