Order of Conditions using Business Objects 5.1.8

[ainkca]

In this older version of Business Objects that I'm using, how can I determine the primary keys (and foreign key) structures of tables in the Universe? I know that later versions(6.5 and higher?) have a tab in the object properties for keys, but can't find anything like that in my version.

I would love to figure out a way to have my reports run more efficiently without guessing at the best order for the objects in my condition panel.

Any suggestions? I know there are some really knowledgeable people on this forum.

THe universe I'm using is from our vendor, and not supposed to be modified. It's connected to an Oracle database, I think version 8 or 9. Should I be trying to find this out on the Oracle side? Not that I'd know how to do that either...

Regards,
ainkca

 

[skrandel]

It isn't possible. The reality is that it doesn't work very well in the newer versions anyway.

The best thing to do is to make sure you have row counts visible in your universe. Then the SQL generated at least has a chance to be fast.

I know the purists are going to say this doesn't matter. But, the reality is that it helps.

Steve Krandel
Intuit

 

[blom0344]

I do not know if I am a purist , but the main focus should be on up-to-date statistics on the database. I can't prove Steve is wrong about having row counts visible. Perhaps it offers BO a chance to do something with the order in which joins are defined.
I vaguely remember that for Oracle there is a setting that manipulates the order in which tables are accessed. That was probably a leftover from the days where rule-based optimizers where still going strong.
If you are on Oracle 9i or newer, then we're talking statistics , possible use of hints and other DBA-stuff.

The only true proof is taking the SQL to the DBA and checking the execution plans. that should yield some advice on optimizing the query from within BO

Ties Blom

 

[skrandel]

That's absolutely right. Stats are the key. We've just found that (even with Oracle 10), some manipulation of the SQL can help. The order of the tables does seem to help a bit. The order of the joins seems to help the most.

Explain plans in Oracle 10 are very good.

Steve Krandel
Intuit