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
