>I can't remember seeing a multiple join query ever get better than partial optimization, but then I haven't checked the optimization level of every query.

The none/partial/full notation refers only to filtering. There's no measurement from SYS(3054) of how much joins are optimized. Instead, it tells you what it's doing.

Tamar