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
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
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
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
