> As I understand it, every query goes through the stages of
> parse,execute, [and possibly fetch(es)].
> Stored procedures can only save you the parse phase (at best) - which is
> usually a tiny component of the total cost/elapsed time (and when it is
> not, then you probably have a data warehouse with an ad-hoc query tool
I'm not so sure about this, parsing can be quite expensive for small result
sets.