MySQL Forums
Forum List  »  Optimizer & Parser

Re: mySQL 8 - view query not using outer predicate
Posted by: Jack Crawford
Date: January 11, 2021 04:04PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mySQL 8 - view query not using outer predicate
312
January 11, 2021 04:04PM


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.