Re: my.cnf file config
Views are saved as literal query text, they aren't compiled nor are their results saved. They organise your queries, they don't help performance.
So let's see ...
- the query on which the View is based,
- results of running Explain on it on the two servers,
- results of Show Create Table for each table referenced by the query, plus any differences in such between the two servers
- my.cnf on the two servers
Subject
Views
Written By
Posted
416
January 02, 2019 02:16PM
Re: my.cnf file config
187
January 02, 2019 02:35PM
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.