You could try using optimizer hints to utilize the cost-based optimizer. Try SELECT/*+ choose */......

You can even gather statistics on the fixed tables and it will affect the execution plan, although I would almost certainly say that Oracle would not support such a thing.

HTH
Gerry