Re: how turn off optimizer?
Without optimizer, MySQL don't know how to execute the query anymore. The optimizer is used to generate an execution plan on how it execute the query.
There is some option for the optimizer on MySQL 5.0, something like how exhausive the optimizer will be. Optimization also takes time and can slow down the query if it takes too long to find the optimal execution plan
Subject
Views
Written By
Posted
3176
November 28, 2006 11:40AM
Re: how turn off optimizer?
2968
November 28, 2006 06:25PM
2353
November 28, 2006 11:24PM
2763
November 30, 2006 02:04AM
2396
December 12, 2006 06:24PM
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.