MySQL Forums
Forum List  »  Optimizer & Parser

Is Union Queries run in Parallel form or not.
Posted by: Azeem Haider
Date: October 17, 2017 11:40PM

I have three tables and I want to select data from these three tables in parallel form to increase the performance.

I'm running query like this.

SELECT * FROM table1
UNION ALL
SELECT * FROM table2
UNION ALL
SELECT * FROM table3

I wan to ask that these queries run in parallel form or in order one by one ?

What can I do to increase the performance of this query. Can I create thread for each query ?

If I create three thread for this query with single connection is it work in parallel or not ? or I need to create three connection for each query to run parallel ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Is Union Queries run in Parallel form or not.
1260
October 17, 2017 11:40PM


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.