I have a table with and index and yet the optimiser chooses a full table scan instead of using it - why does this happen? Can I force it to use the index?
create table test(id smallint, seq smallint, type smallint); select id, seq, type from test where type < 1000; -- View this message in context: http://old.nabble.com/Why-does-the-query-optimiser-not-use-the-tables-index--tp33310718p33310718.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
