Re: Expland and slow-query don't agree
Posted by:
Rick James
Date: August 04, 2014 01:23PM
What's the relevance of "Expland and slow-query don't agree"?
Sorry, but your explanation of the UNION is too much 'hand waving'; please show us the entire SELECT. (Maybe you can leave some pieces that are not problematical.)
> am I better off selecting each piece into a variable and then selecting the variables?
Better off why? A single big UNION is probably faster because of fewer statements to perform.
We'll probably need the SHOW CREATE TABLEs to see the datatypes, engines, and indexes, too.
Subject
Views
Written By
Posted
2151
August 03, 2014 06:24AM
Re: Expland and slow-query don't agree
1136
August 04, 2014 01:23PM
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.