MySQL, Query, Optimization, Web Performance, Database.
expression calculation; where do not perform expression calculations on the field, the use of functions 6, identity transformation, inequality transformation. Example: Testing millions of data a>b and b>10 becomes a>b and a>10 and b>10 optimization is significant 9. External connection optimization