Edson Carlos Ericksson Richter wrote:
I've run with derby.language.logQueryPlan=true and result is that I
have table scan for only one table, that has actually one record.
I am curious as to why a table scan is being picked. Does this table
have indexes that can be used for the query in question ? Also what
isolation level is this query running at.
Sunitha.
The most costing queries are sub-selects (cost 13525) inside a almost
large query, but everything is being run either using indexes (cost
between 13 and 25) or hashed joins (throught PK, with cost between 50
and 80).
Richter.
