Daniel,
Somehow oracle seems to know that a right join is the better way to go.
In fact, PostgreSQL is just doing the same thing: it hashes smaller table
and scans the bigger one.
Could you please clarify how do you consume 25M rows?
It could be the difference of response times comes not from
Guys, thanks a lot for your input. It is very valuable for us. We plan to
fix a separate dev server similar to production one, copy all data there
and try you suggestions as we really don't want to do it on production
server. I also noticed that IOPS jumps to 100% when running this query. So
it is
On Wed, Jan 9, 2013 at 9:49 AM, Alex Vinnik alvinni...@gmail.com wrote:
Guys, thanks a lot for your input. It is very valuable for us. We plan to
fix a separate dev server similar to production one, copy all data there and
try you suggestions as we really don't want to do it on production