Re: mySQL 8 - view query not using outer predicate
Does this answer your question?
Quote
The optimizer propagates an ORDER BY clause in a derived table or view reference to the outer query block if these conditions are all true:
The outer query is not grouped or aggregated.
...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Edited 1 time(s). Last edit at 01/11/2021 01:38PM by Peter Brawley.
Subject
Views
Written By
Posted
948
January 11, 2021 10:49AM
463
January 11, 2021 12:07PM
483
January 11, 2021 12:18PM
Re: mySQL 8 - view query not using outer predicate
472
January 11, 2021 01:38PM
483
January 11, 2021 02:06PM
433
January 11, 2021 03:02PM
470
January 11, 2021 04:04PM
448
January 11, 2021 10:34PM
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.