> Martijn Tonies
> Can you show us the full table DDL?

CREATE TABLE CUSTOMERS
(
LINK VARCHAR( 10) NOT NULL COLLATE NONE,
DELETED CHAR( 1) COLLATE NONE,
TELEPHONE VARCHAR( 15) COLLATE NONE,
CEL VARCHAR( 12) COLLATE NONE,
SURNAME VARCHAR( 36) COLLATE NONE,
"NAME" VARCHAR( 36) COLLATE NONE,
ADDRESS1 VARCHAR( 36) COLLATE NONE,
ADDRESS2 VARCHAR( 36) COLLATE NONE,
ADDRESS3 VARCHAR( 36) COLLATE NONE,
ADDRESS4 VARCHAR( 36) COLLATE NONE,
SUBURBLINK VARCHAR( 10) COLLATE NONE,
ORDERS FLOAT,
LASTORDERDATE DATE,
LASTORDERTIME TIME,
LASTORDERLINK VARCHAR( 10) COLLATE NONE,
SPENT NUMERIC( 15, 2),
CREDITCARD VARCHAR( 24) COLLATE NONE,
CVC CHAR( 3) COLLATE NONE,
EXPDATE VARCHAR( 5) COLLATE NONE,
TELVALID FLOAT,
BIRTHDATE DATE,
ADDDATE DATE,
ADDUSER VARCHAR( 10) COLLATE NONE,
EMAIL VARCHAR( 40) COLLATE NONE,
WEBPASSWORD VARCHAR( 15) COLLATE NONE,
RANKING FLOAT,
MTD NUMERIC( 15, 2),
MONTHORDERS FLOAT,
IDNUMBER VARCHAR( 15) COLLATE NONE,
COMPANY CHAR( 1) COLLATE NONE,
DNOTES_ENABLED CHAR( 1) COLLATE NONE,
DNOTES_TOTAL NUMERIC( 15, 2),
DNOTES_VOUCHER VARCHAR( 16) COLLATE NONE,
DNOTES_USER VARCHAR( 10) COLLATE NONE,
DNOTES_SINCE DATE,
REMARKS VARCHAR( 450) COLLATE NONE,
INHOUSE VARCHAR( 450) COLLATE NONE,
LASTUPDT DATE,
CONSTRAINT CUSTOMERS_PRIMARY PRIMARY KEY (LINK)
);

CREATE DESC INDEX I_CUSTOMERS_SPENT ON CUSTOMERS (SPENT);
CREATE ASC INDEX I_CUSTOMERS_SUBURBLINK ON CUSTOMERS (SUBURBLINK);
CREATE ASC INDEX INDEX_CEL ON CUSTOMERS (CEL);
CREATE ASC INDEX INDEX_SURNAME ON CUSTOMERS (SURNAME);
CREATE ASC INDEX INDEX_TELEPHONE ON CUSTOMERS (TELEPHONE);

table has 12123 rows

Martin,
it does this on all of my tables when I do a search on the PK
I use firebird 1.5.2
I have done a full backup and restore with no changes
If I create an additional index on customers(link) everything works as
expected ie. 1 indexed read with plan INDEX (I_CUSTOMERS_LINK)

TIA
Gary