When the procedure is executed, each query in the procedure is obviously
run through the query optimizer. But the flags are symbolic only for
humans.
2011/12/9 Halász Sándor
> ;>>> 2011/12/08 10:21 -0500, Singer X.J. Wang
> But again one of the flags are binding in any way. There's nothi
I am not sure that the db engineers should look into supporting recursive
optimizations. That sounds to me like a waste of their time, and conversely
an investment in your (my) time. This kind of thing is far too app-specific
to generalize into an all-encompassing algorithm, IMO, and even if it cou
I didn't say anything about recursive optimizations. All I said was the
following statement:
"When the procedure is executed, each query in the procedure is obviously
run through the query optimizer. "
2011/12/13 Arthur Fuller
> I am not sure that the db engineers should look into supporting re
Hello All,
On 12/5/2011 14:20, wrote:
A procedure MODIFIES SQL DATA if all the modifying involves a temporary table,
or only READS SQL DATA?
Does it matter whether the temporary table is meant to outlast the
procedure-call?
Many of you are missing the big picture. This flag (along with m
