Holger Schurig | 5 Jan 2005 08:32
Picon
Favicon

Re: AW: OPTIM_CACHE and implications?

> IMHO you should set OPTIM_CACHE=YES if
> you have steady data base and steady queries against this database. If
> you have dynamic data base and vary parameters on same query templates
> this could lead to bad query execution plans.

Thanks for this explanation.

Under which circumstances get the cached queries get deleted and 
re-created?

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org


Gmane