I examined this idea by utilizing a t1.code with the extremely earliest rows and the response is sub-second utilizing the same prepare.What I feel tends to make my Top rated prepare so negative would be that the rows being picked from t1 and t2 are several of the newest rows (biggest values for t1.id and t2.id). The question optimiser has assumed t