NTT DATA interview question

How will you optimise the Stored Procedure?