Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> powerbuilder in rbo and multiple constraint question...

powerbuilder in rbo and multiple constraint question...

From: Chris Stephens <>
Date: Thu, 15 Jan 2004 06:54:36 -0800
Message-ID: <>

I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure?

..and on a side company is developing a call center app in .not.
The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint?
.........when I saw this, I blasted the developers (admittedly some
misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if bind variables for one) would negatively affect performance.
..after possibly putting my foot in my mouth I'm looking to validate what I
said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. ....oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either.


Please see the official ORACLE-L FAQ:
Author: Chris Stephens

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 15 2004 - 08:54:36 CST

Original text of this message