What is the main performance benefit of using a stored procedure (SP) over repeatedly executing raw SQL statements?

Question

What is the  main performance benefit  of using a stored procedure (SP) over repeatedly executing raw SQL statements?

Answer

c.  SPs reduce network traffic since only the call is sent, not the full SQL text

Answer

a.  SPs always execute faster because they bypass the optimizer

Answer

b.  SPs automatically create indexes on frequently used columns

Answer

d.  SPs compress results before sending to client

Crowdly