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?