I've upgraded my DB to 7.3.1 from 7.2. The following update causes the SEQ
SCAN instead of INDEX SCAN (in 7.2 there was no bug like that):
create table machines(
i_sprzetx int,
mod char(10),
type char(30)
);
create table sprzetx(
rowid int,
ident char(50)
);
create index i_sprzetx on sprzet
Check the CREATE TABLE statement. Possibly you use VARCHAR type and your
data has trailling spaces. Try to TRIM all the data in your database or
remove trailling spaces using text editor.
---(end of broadcast)---
TIP 9: the planner will ignore you
