A star join plan utilizing push-down hash join technology makes hash joins more effective primarily due to reduction of fact table (probe table) rows early on.
It may seem like a little thing, but using the % freedb_searches hash to get the list of searching switches makes the code shorter and more maintainable.