Hi Max, this is a follow-up to the information I tried to give:
create the table TOF with primary key specified : CREATE TABLE TOF ( a INTEGER, b CHAR(9), PRIMARY KEY(a,b) ) show how criteria on column "a" only would be honored (with SQLStudio): explain select * from TOF WHERE A=4711 OWNER; TABLENAME; COLUMN_OR_INDEX; STRATEGY; PAGECOUNT; O; D; T; M XXX; TOF; ;RANGE CONDITION FOR KEY COLUMN; 38; ; ; ; ; ; A; (USED KEY COLUMN); ; ; ; ; XXX; ; ; RESULT IS NOT COPIED , COSTVALUE IS; 2; ; ; ; (with actual data and updated statistics the PAGECOUNT would surely be more accurate) regards wolf nücker ________________________________________________________________ Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
