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?
