db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lasantha Siriwardana <lasantha.siriward...@gmail.com>
Subject Derby In-Memory DB is not using any available indexes
Date Fri, 13 Dec 2013 01:36:14 GMT
Hi All,

I've setup an derby in-memory db using derby distribution 10.10.1.1. Below
are the configurations;
Max Heap Size - 3GB
Page Cache Size - 10000
I stored nearly one million records in a table with around 50 columns and
trying to retrieve the data. But the query takes ~10sec. When I check the
explain plan, It's not used any index and the optimizer cost is very
higher. Also the scan type was heap. Please help to resolve this issue and
tuneup the query. Why doesn't derby in-memory use indexes?

Lasantha

Mime
View raw message