Re: MySQL 8.0 - View Performance
> The initial SQL without any subviews hasn't run successfully in MySql.
Then it needs first to be optimised as a straight query with all its subqueries.
For help with that, please post the query with ...
- Show Create Table results for each referenced table
- inside BBCode code tags, the results of running Explain on the query
- innodb_buffer_pool_size setting
- Tail of Show Engine InnoDB Status whilst the query is running
Subject
Views
Written By
Posted
1788
September 20, 2019 07:47PM
1656
September 20, 2019 09:14PM
640
September 20, 2019 10:29PM
Re: MySQL 8.0 - View Performance
661
September 20, 2019 11:18PM
782
September 21, 2019 12:18AM
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.