MySQL Forums
Forum List  »  Optimizer & Parser

Optimizer Stablility
Posted by: Chris Reston
Date: August 16, 2017 12:56AM

Hi All,

I have a colleague at work who strongly opposes the use of VIEWs in MySQL. One of the reasons he gives is (quote):

"Unpredictable performance, the performance of a query might degrade by orders of magnitude if the optimizer decides on a different solution. This can happen at any time and without warning."

This seems very strange to me. As far as I know the only time the optimizer strategy can change is on database upgrade, but even then the performance should be predictable (i.e. more or less constant under the same circumstances).

Is there anything in his statement?


Options: ReplyQuote

Written By
Optimizer Stablility
August 16, 2017 12:56AM
August 16, 2017 02:19AM

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.