Toad World® Forums

Analyze Joins - multiple join keys

Hi!

The use of Analyze Joins is sometimes very usefull.

If you have a join by more than 1 foreign key will the anayzes then be performed on the multi key join or the one you are clicking on?

It looks to me like it is the former, using all keys.

Not sure if this is usefull but what if you want to see the consequence of ommiting a key in the join and therefore would like to perform the analyses on just one/some of the keys?

Arne

If you have a multi key join then you would see the joining analysis based on all the keys. We would continue to analyze in this way so that you get the whole picture as apposed to just analyzing a particular join.