Re: Slow Query, Optimization Advice Needed

[Michael Lawson]

Version is 5.5.45-37.4-log

Explain is:

id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY TL ref nMovementOutID,nTrailerID_nMovementInID_nMovementO... nMovementOutID 4 const 10553 Using temporary; Using filesort
1 PRIMARY T eq_ref PRIMARY,nTrailerVendorID,eStatus PRIMARY 4 trailype_new.TL.nTrailerID 1 Using where
1 PRIMARY TV eq_ref PRIMARY PRIMARY 4 trailype_new.T.nTrailerVendorID 1 Using where
1 PRIMARY M ref nTrailerID,nLocationID nTrailerID 4 trailype_new.TL.nTrailerID 2 Using where
1 PRIMARY L eq_ref PRIMARY PRIMARY 4 trailype_new.M.nLocationID 1
2 DEPENDENT SUBQUERY M2 index_subquery tsMovement,nTrailerID nTrailerID 4 func 2 Using where