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