This is a description of optimize1.gif.

Step 1: Scan table t1 and sort using a temporary range index.

Step 2: Scan table t2 and sort using a temporary range index. After scan, return the rows that match: t2.b<>0.

Step 1 and Step 2 are on Level 3.

Step 3: Merge results from Steps 1 and 2 and join the rows that match: t1.a=-t2.a.

Step 4: Scan table t3 and sort using a temporary range index.

Step 3 and Step 4 are on Level 2.

Step 5: Merge results from Steps 3 and 4 and join the rows that match: t2.a=T3.a. After join, return the rows that match: t3.b/t1.b>1.

Step 5 is on level 1.

End of description.