Barclays interview question

Questions around indexes and table structures