2 ms·
With one exception: joining over database links is terrible. I admit that it's a hard problem to solve, but still. Just yesterday I rewrote a view that used a
by jacques_chester 16y ago
With one exception: joining over database links is terrible. I admit that it's a hard problem to solve, but still.
Just yesterday I rewrote a view that used a database link to act as a materialized view (which makes me feel icky). It ran approximately 10,000 times faster. For a 100-row result that only joins 4 modest tables, there shouldn't be that kind of a difference IMO.