db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject any explanation of pointbase performance in results posted in DERBY-465? Do they automatically create indexes?
Date Wed, 20 Jul 2005 18:34:50 GMT
The results posted in DERBY-465 seem to indicate that somehow
pointbase can execute select * from table where nonkey=5000 at
a constant performance no matter how many rows in the table with
no index on "nonkey".

Not surprisingly derby performance on this query is linearly
related to the size of the table with no index.  Performance is
constant when an index is added.

Does anyone know if pointbase somehow automatically creates
and maintains indexes, maybe as directed by the optimizer?

View raw message