Re: optimize request with order by and limit

[yassine laouija]

So how can i rearrange the fields in the tables ? and how execute the joins before order by and limit, we can reorganize the request that you sended me ?

SELECT TrkTypeID, TrkID, st.Alias
FROM
( SELECT trk.TrkTypeID , trk.TrkID , jb.StartDate,
jb.StatusTypeId
FROM tracking trk
INNER JOIN TrackingEnv trkenv ON trk.TrkID = trkenv.TrkID
INNER JOIN Job jb on jb.JobID=trk.JobID
WHERE trk.TrkTypeID IN ( 2,3,10)
AND trkenv.EnvID IN ( 1,1,20 )
Order BY jb.StartDate DESC
LIMIT 0 , 10 ) foo
JOIN statustype st on st.StatusTypeID = foo.StatusTypeID