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}
Kane, David wrote:
Here are the indexes that are being reported on the ASSOCIATION table:
[ snip index display ]
Hate to be a nuisance, but can you post the DDL for the tables in the query? I
find it easier to make sense of the DDL than to parse the index table (maybe
it's just me). You