PB 12.5.1
Every time I go into the SQL of a DataWindow I am left twiddling my thumbs for x number of seconds waiting for the SQL to show. When I query the DB to find out what is it doing it returns a Select against the data dictionary. I realize that this is an Oracle issue (those have gotten very slow in 11g) but it there a way to tell PB not to do this query?
Query:
SELECT F.CONSTRAINT_NAME,F.OWNER,F.R_OWNER,P.TABLE_NAME,SYS.ALL_CONS_COLUMNS.COLUMN_NAME,F.DELETE_RULE
FROM SYS.ALL_CONSTRAINTS F, SYS.ALL_CONS_COLUMNS,SYS.ALL_CONSTRAINTS P
WHERE F.OWNER = 'COMPANY_23' AND F.TABLE_NAME = 'IC_PRODUCT_UOM' AND F.CONSTRAINT_TYPE ='R' AND SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME = F.CONSTRAINT_NAME AND SYS.ALL_CONS_COLUMNS.TABLE_NAME = 'IC_PRODUCT_UOM' AND SYS.ALL_CONS_COLUMNS.OWNER = 'COMPANY_23' AND P.OWNER = F.R_OWNER AND P.CONSTRAINT_NAME = F.R_CONSTRAINT_NAME ORDER BY F.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION
Thanks,
Chris Craft