SQL Order

[dbomrrsm]

Webi 6.5

We have a number of queries that are performing rather slowly.

When we lloked at the sql the order in which the joins are done seems to have an effect on performance - a BO produced piece of sql ran in 1.20 minutes but with it rewritten withn ONLY the join order chaged it returns in 5 seconds.

Is there a way of determining the order in which the selected tables appear in the sql.

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[blom0344]

If you use ORACLE then do a search here on the topic
'reverse table weight'.
I recall giving an answer to a similar question, but yours may be more generic...

Ties Blom

 

[dbomrrsm]

Ties

Thanks for the input but your search criteria returned no results in this forum.

We do indeed use Oracle so your previous answer will probably be very useful if you can point me at it.

Thanks

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[blom0344]

look here:

http://www.tek-tips.com/viewthread.cfm?qid=1092768&page=2

Ties Blom

 

[dbomrrsm]

Cheers

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]