Hmm, what are the implications of setting parameter OPTIM_CACHE to YES? The default is NO.
----------------- Used to optimize strategy detection (YES/NO) EXPLAIN OPTIM_CACHE 'YES' or 'NO' 'YES': strategy is only detected once for a parsed statement 'NO' : strategy is detected at every execution of a parsed statement ----------------- THis help from "dbmcli -d TST -u dba,dba param_getfull OPTIM_CACHE" did not really tell anything. Why is it set to NO, does the cache use too much size? Does the cache get cleared on "UPDATE STATISTICS" or on dbmcli sql_updatestat? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
