| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: powerbuilder in rbo and multiple constraint question...
Chris,
I've worked on a large Powerbuilder App for a number of years. We used CBO all the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se requiring RBO is rubbish.
Cheers,
Chris Dunscombe
Quoting Chris Stephens <ChrisStephens_at_affina.com>:
> 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 note...my 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
> found...no 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.
>
> Thanks!
> chris
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chris Stephens
> INET: ChrisStephens_at_affina.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
>
Chris Dunscombe
chris_at_thedunscombes.f2s.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: chris_at_thedunscombes.f2s.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 Fri Jan 16 2004 - 03:24:26 CST
 |
 |