MySQL, Query, Optimization, Web Performance, Database.
there are a few cases are used, so the specific situation is analyzed. Similar optimization: Select * from tab name=’aa’ or name=’bb’; => Select * from tab name=’aa’ Union all Select * from tab name=’bb’; Actual measurement: 1, 100,000 data test, without any index, the above is twice as fast as the