7.2 win32 fixpack 10a
This is part of "call procedure" statement
SELECT A.PROCSCHEMA, A.PROCNAME, A.PARMNAME, A.TYPESCHEMA, A.TYPENAME,
CASE WHEN TYPENAME = 'VARGRAPHIC' THEN A.LENGTH/2 ELSE A.LENGTH END,
A.SCALE,
A.PARM_MODE, A.ORDINAL, A.CODEPAGE
FROM "SYSIBM".SYSPROCPARMS A, "SYSIBM".SYSPROCEDURES B
WHERE
B.PROCSCHEMA = 'SCHEMA'AND B.PROCNAME = 'PROCNAME'
AND A.SPECIFICNAME = B.SPECIFICNAME AND A.PROCSCHEMA = B.PROCSCHEMA AND
B.PARM_COUNT = 1
We have near 14000 rows in first table and 3200 in second. This sql is not
optimal when explain. May be rewrite to
...
WHERE
A.PROCSCHEMA = 'SCHEMA'AND A.PROCNAME = 'PROCNAME'
...
?
Regards,
Andy