Hi.
going from 8.1.2 to 8.1.11, make our stored procedures very slow, here
is an example:
 select a, b from t1 a
      join t2 b on a.bkr=b.bkr
      and  (a.act_id=b.act_id or (substr(a.act, 1, 2)=b.act
              and (substr(a.act, 1, 1)<='z' and (substr(a.act, 1,
1))>='a') ))
      join t3 c  on b.bkr=c.bkr
      join t4 r  on c.bkr=r.bkr
      join t5 e on a.fi=e.fi
 where a.bkr=ipbkr_num
    .
    .
this select to insert to temp_table never finish, but:
1- if I remove .. and  (a.act_id=b.act_id or (substr(a.act, 1, 2)=b.act

              and (substr(a.act, 1, 1)<='z' and (substr(a.act, 1,
1))>='a') ))
   finish fast as before upgrade.
2- if I replace: where a.bkr=ipbkr_num  to where a.bkr='AAA'
   finish fast as before upgrade.

any idea of any special config. params tuneup.
thanks in advance
fayez