Is Union Queries run in Parallel form or not.
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 ?
Subject
Views
Written By
Posted
Is Union Queries run in Parallel form or not.
1260
October 17, 2017 11:40PM
782
October 18, 2017 08:32AM
1088
October 18, 2017 10:43PM
684
October 18, 2017 10:55PM
810
October 19, 2017 03:02AM
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.