Florian Schmitz wrote: > Another strange fact : > > Even tough HASHED_RESULTSETS is NO, an explain shows the > Server building hased resultsets, which > gives horrible results in our case. > > Any clue?
Hi, to avoid hashed resultsets in join execution you have to set database parameter MAX_SINGLE_HASHTABLE_SIZE = 0. With HASHED_RESULTSETS = NO you avoid hashed resultsets at set function execution. It's a little bit confusing. But I couldn't believe that hashing is your problem. Could you give more information about the problem? Kind regards Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
