MySQL Forums
Forum List  »  Optimizer & Parser

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

Thanks but I don't think so.

I'm looking to have the predicate on the call to the outer query (the query that invokes the view) propagated to the view query.

This would allow me to change the predicates used to select records (in my client apps for example) while maintaining the same view (the same columns selected) across all uses of the view.

Without this propagation the temp table result is simply too large to be practical.

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.