> What is the plan? I suspect some hardcoded limit for the hash join > algorithm has been reached. Do you see HASH in the plan?
Here's the plan: PLAN HASH (EMTD NATURAL, JOIN (SORT (DR DR NATURAL), EWR INDEX (IDX_EWR_SENT_A_TEMP))) Could I somehow confirm it's this? And more importantly how can I prevent falling into this trap? :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
