ServiceNow interview question

How to use Join and Indexing in MySQL