Well, the thread is really old but I'll post my suggestion here anyway. Use local join hint, it makes the optimizer to force join order. And can be used in a view.