select t1.* from t1, t2 where t1.t1id= t2.t1id
t2需要建t1id索引
select t1.*,t2.name from t1, t2 where t1.t1id= t2.t1id
t2需要建t1id,name索引
select t1.* from t1, t2 where t1.t1id= t2.t1id
t2需要建t1id索引
select t1.*,t2.name from t1, t2 where t1.t1id= t2.t1id
t2需要建t1id,name索引