MySQL, Query, Optimization, Web Performance, Database.
the field name of the leftmost prefix of the index 2, replace exists in Select num from a where num in(select num from b) Select num from a where exists(select 1 from b where num=a.num) One million pieces of data, screening 59,417 pieces of data took 6.65s, 4.18s. No other optimizations, just