Re: OT: Business Objects

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: sacrophyte@xxxxxxxxx
  • Date: Mon, 30 Apr 2007 15:29:22 -0500


   My impression is that B.O. usually generates good SQL, and when it
doesn't, it has features which allows report developers to improve the SQL.
This is based on the fact that I have had to deal with relatively few
   My impression is that B.O. is a sophisticated tool that usually
generates good SQL, and has advanced options when difficulties are
   As far as other products creating better SQL, that might be difficult to
get a trustworthy blanket statement. These are complex products generating
complex SQL in (your case) complex situations. Not sure how that could even
be tested.
   Your last statement makes it sound like this is a difficult situation.
One thought would be whether you as the DBA can take the SQL statements that
are generated by B.O., rewrite them for your developers and then have your
developers try to figure out how to get B.O. to generate similar SQL, asking
B.O. support as needed.

Dennis Williams

Other related posts: