IQVIA interview question

4) performance tuning questions, explain plan, index creation