Search

Top 60 Oracle Blogs

Recent comments

18

MERGE JOIN CARTESIAN: a join method or a join type?

By Franck Pachot

.
I’ll present about join methods at POUG and DOAG. I’ll show how the different join methods work in order to better understand them. The idea is to show Nested Loops, Hash Join, Sort Merge Join, Merge Join Cartesian on the same query. I’ll run a simple join between DEPT and EMP with the USE_NL, USE_HASH, USE_MERGE and USE_MERGE_CARTESIAN hints. I’ll show the execution plan, with SQL Monitoring in text mode. And I’ll put some gdb breakpoints on the ‘qer’ (query execution rowsource) functions to run the plan operations step by step. Then I’ll do the same on a different query in order to show in detail the 12c adaptive plans.

Fedora 18 : The winner is MATE (so far)…

I’m a few days into Fedora 18 and I think I’ve come the the conclusion that the desktop that best suits *me* is MATE. The journey to this point has been a rather long and meandering one. Let’s cut it short and start at GNOME2.