db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anthonyri <anthony.r...@inbox.com>
Subject Why does the query optimiser not use the tables index?
Date Sun, 12 Feb 2012 17:10:04 GMT

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.


Mime
View raw message