What happens when you update the table statistics? Oracle's cost based optimizer does strange things when its using outdated or non-existent statistics. Just tossing out an idea that you might have ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results