Hubar Tech interview question

1. Database question about join, indexing