Re: Creating Views problem in 5.6/5.7
Ok, vanilla joins but lots of them; some 5.6-7 optimisation changes may be having effects, going to need to look at ...
- Explain result for the three queries used in those Create View statements in each of 5.5 and 5.7, each Explain result inside
BBCode [ code ] [ /code ] tags without the spaces (for readability)
- Show Create Table results for the referenced base tables
- my.ini settings
- either the results of show variables and of show engine innodb status\G, or the result of running the "cheatsheet" code under that heading at
https://www.artfulsoftware.com/infotree/mysqltips.php
Subject
Views
Written By
Posted
1054
June 22, 2017 02:12PM
553
June 22, 2017 03:55PM
576
June 22, 2017 04:12PM
Re: Creating Views problem in 5.6/5.7
510
June 22, 2017 06: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.