Subject Plan evaluation in stored procedures
Author Aldo Caruso

I have a complex join query and I'm tempted to use a stored
procedure for simplicity from the client point of view.
My question is: does the optimizer evaluates the plan for the query
each time the stored procedure is excecuted or is it evaluated only
once, when the stored procedure is compiled to BLR.
In the latter case it would be a dissadvantage because as time
passes, table cardinality and indeces distribution vary, and if the plan
was frozen at the stored procedure compilation time, may be that it
would't be optimal any more.