Re: mySQL 8 - view query not using outer predicate
Thanks.
What I'm trying to accomplish is to have the optimizer push down the predicate:
line_item_auto_key = 1112121
to the view.
My reading of this is that this would be accomplished if the optimizer derived_condition_pushdown=on
Subject
Views
Written By
Posted
1162
January 11, 2021 10:49AM
523
January 11, 2021 12:07PM
557
January 11, 2021 12:18PM
546
January 11, 2021 01:38PM
568
January 11, 2021 02:06PM
494
January 11, 2021 03:02PM
Re: mySQL 8 - view query not using outer predicate
539
January 11, 2021 04:04PM
515
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.