Thanks for your reply. I think my database is in problem, because when I tried to restored it, I got error
Engine Message : validation error for column ID_DIV_LC, value "*** null ***" warning -- record could not be restored I think, may be there is a leak in Firebird to trap an error when null value allowed to store in a not null value definition. I forgot how to insert this null value to the database. Thanks and regards, Sugiarto > What's the execution plan? If it's using an index on ID_DIV_LC and the > following returns a result set: > > select > * > from > m_int_frm a > where > a.id_trs_typ = 100 > and a.id_div_lc + 0 = 0 > > > Then your index on ID_DIV_LC might be problematic/corrupted. > > > -- > With regards, > Thomas Steinmaurer (^TS^) > Firebird Technology Evangelist > > http://www.upscene.com/ > > Do you care about the future of Firebird? Join the Firebird Foundation: > http://www.firebirdsql.org/en/firebird-foundation/ >