Infosys interview question

transaction stored procedures array vs array list performance tuning left and right joins