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
1709
September 20, 2019 07:47PM
1582
September 20, 2019 09:14PM
598
September 20, 2019 10:29PM
Re: MySQL 8.0 - View Performance
620
September 20, 2019 11:18PM
738
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.