>Thanks Sergey, I thought that was the case but I haven't mastered reading the results to the sys(3054) yet. Do you know if there is something more user friendly/understandable available?

SYS(3054) is all we've got for this. The key point in the example you gave is that because the Country table isn't filtered, optimization is listed as none.

Tamar