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
Subject
Views
Written By
Posted
2818
August 27, 2014 07:08AM
1470
August 27, 2014 07:19AM
Re: Not Taking Paritioning when using Subquery or Join
1546
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.