Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

PowerBuilder performance issue?

Hello all,

we have a PowerBuilder application and we have noticed a performance issue. It seems that the following SQL statement is called continuously and it causes severe delays and performance impact:

SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM

SYS.ALL_CONSTRAINTS,SYS.ALL_CONS_COLUMNS WHERE  SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND

SYS.ALL_CONSTRAINTS.TABLE_NAME = 'OLRIVI' AND    SYS.ALL_CONSTRAINTS.OWNER = 'XYZ' AND

SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND

SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND    SYS.ALL_CONSTRAINTS.OWNER =

SYS.ALL_CONS_COLUMNS.OWNER ORDER BY

SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME,SYS.ALL_CONS_COLUMNS.POSITION

The database versions are 10g and 11g. Any ideas, how to cache, speedup or turn off the statement?

Thanks in advance,

Mika

Former Member
Not what you were looking for? View more on this topic or Ask a question