MySQL Forums :: Partitioning :: Not Taking Paritioning when using Subquery or Join


Advanced Search

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
Not Taking Paritioning when using Subquery or Join 1873 Marc Vettorel 08/27/2014 07:08AM
Re: Not Taking Paritioning when using Subquery or Join 1017 Marc Vettorel 08/27/2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join 1006 Rick James 08/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.