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