db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: Very slow
Date Tue, 31 May 2005 20:58:12 GMT
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.



Mime
View raw message