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
1326
January 02, 2019 02:16PM
Re: my.cnf file config
464
January 02, 2019 02:35PM
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.