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 <fuller.art...@gmail.com> > 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 could > be done, I would rather the engineers spend their time on more significant > problems. > > Just my $0.02. > Arthur > > 2011/12/9 Halász Sándor <h...@tbbs.net> > > > >>>> 2011/12/09 20:37 -0500, Singer X.J. Wang >>>> > > 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. > > <<<<<<<< > > "Obviously"? As I wrote, someone said that the optimizer does _not_ look > > into procedures. > > > > "Symbolic" is not right: do you mean "meaningful"? If "meaningful", that > > is to say that the flags are completely useless. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql > > > > > > > -- > Cell: 647.710.1314 > > Thirty spokes converge on a hub > but it's the emptiness > that makes a wheel work > -- from the Daodejing > -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
