MySQL Forums
Forum List  »  Partitioning

Re: Not Taking Paritioning when using Subquery or Join
Posted by: Rick James
Date: August 28, 2014 10:19AM

IN (SELECT...) is notoriously bad. Use JOIN instead.

What do you get from
select  *
    from  art_prices AS a
    JOIN  imports i USING(import_id)
    where  i.import_id = 1998
and from
EXPLAIN PARTITIONS select  *
    from  art_prices AS a
    JOIN  imports i USING(import_id)
    where  i.import_id = 1998 

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Not Taking Paritioning when using Subquery or Join
1039
August 28, 2014 10:19AM


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.