Sp is precompiled query

We have to execute While procedure is compiled

Stored procedure will not compile again and again where simple Query compile every time then execute.From my side store procedure will be good.