Hi,
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.
Thanks,
Aldo
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
