db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Klebanoff <klebanoff-de...@sbcglobal.net>
Subject Re: Very slow
Date Wed, 01 Jun 2005 15:21:11 GMT
Sunitha Kambhampati wrote:

> 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.
>
If the table only has one row then a table scan is faster than an index 
scan.

Jack

Mime
View raw message