MySQL Forums
Forum List  »  Optimizer & Parser

Re: Complex query - need advise
Posted by: chris boer
Date: November 03, 2012 04:24PM

id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> system 1
1 PRIMARY <derived4> system 1
4 DERIVED Media ALL 4376 Using where
5 DEPENDENT SUBQUERY m ref PlacementID,CampaignName PlacementID 5 func 2 Using where; Using temporary
5 DEPENDENT SUBQUERY mm ALL 4376 Using where; Using join buffer
2 DERIVED Delivery ALL 1784 Using where
3 DEPENDENT SUBQUERY m ref AdID,PlacementID,CampaignName AdID 5 func 1 Using where; Using temporary
3 DEPENDENT SUBQUERY d eq_ref PRIMARY,AdID PRIMARY 4 func 1 Using where; Using index
3 DEPENDENT SUBQUERY mm ALL 4376 Using where; Distinct; Using join buffer



Edited 1 time(s). Last edit at 11/03/2012 04:25PM by chris boer.

Options: ReplyQuote


Subject
Views
Written By
Posted
2713
November 03, 2012 04:16PM
Re: Complex query - need advise
1333
November 03, 2012 04:24PM
1315
November 04, 2012 10:05AM
1606
November 05, 2012 11:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.