db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Performance Tuning Problem
Date Mon, 09 Apr 2007 19:50:20 GMT
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


Mime
View raw message