Re: how can I connect multiple select queries via UNION ALL.
It seems unlikely a user could learn anything from looking at the result of such a query, so presumably it's meant to be further processed.
In any case, the 61-table limit is hardwired AFAIK. What's more, Join Order optimisation complexity increases as the factorial of the table count, so attempts to skirt the 61-table limit are futile on both counts.
If it's me, I chunk the joins to generate intermediate tables.
Quote
LEFT JOIN sources AS sor
ON sor.id = meso.source_id
( SELECT m.id AS id, ...
That's a From clause syntax error.
Subject
Written By
Posted
Re: how can I connect multiple select queries via UNION ALL.
June 29, 2020 02:01PM
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.