Do you have indexes on the important columns of the ASSOCIATION table? From a quick peek at your query plan, this seems to be killing you:
Right result set: Table Scan ResultSet for ASSOCIATION ... scan information: Bit set of columns fetched={1, 2} Number of columns fetched=2 Number of pages visited=55790 Number of rows qualified=14 Number of rows visited=10488516 Scan type=heap It's scanning through 10 million rows in the ASSOCIATION table... thanks, bryan