Hi Dorin

>Hi, pardon me for jumping in

No problem, you are most welcome. Before I forget your cbo-grid class in the downloads does it now work in grids?

>The requirement for indexes in Firebird is the same: Selectivity, as high as is possible. Do this and it will be happy - You don't get burned :).

Yup and the better thing is I did not have to issue any SPT to set indexes sort of. I had a SPT which worked okay. I then indexed the data on the same ORDER BY and whoosh it speeded up just like that.

>A SET STATISTICS INDEX {index} can be useful from time to time, specially after a bulk load.

There now, you will have to explain, is this a sort of REINDEX?