Hello again,

now I have insert an index for the first both fields, the ibexpert analysis shows me non indexed reads, why? The stored procedure also looking for two other fields.

SELECT 1 FROM rdb$database WHERE EXISTS(SELECT * FROM t_errordata WHERE kd_id = :t_timestamp

      and li_id = :i_li and ftyp = :i_ftyp and ((fnr >= :i_fnr) and (fnr <= :i_fnr + (:fanzds-1)))) INTO :idexists;

kd_id and li_id now indexed (in one index) ftyp and fnr not. The analysis said there are 1 indexed read, bevore I inserted the index there are thousends non indexed…