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 <h...@tbbs.net> > ;>>> 2011/12/08 10:21 -0500, Singer X.J. Wang >>>> > But again one of the flags are binding in any way. There's nothing > preventing me from declaring my procedure > > * READS SQL DATA indicates that the routine contains statements that > read data (for example, < > http://dev.mysql.com/doc/refman/5.0/en/select.html>SELECT), but not > statements that write data. > And then have it write data.. > <<<<<<<< > Which is to say, it is not good for much, not for the optimizer, either? > Someone else suggested that the optimizer does not look inside procedures, > at most at the flags. Well, which is it? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com