HSBC Interview Question

Define Joins and index with examples