Hi, Nadya.

>Here is the latest code. I presently have index on SearchTB only. Adding indexes on empty(InsCommand) and others doesn't speed it up but rather slow it down. Can this piece of code be re-worked to achieve maximum performance?

There is no silver bullet for data access optimization. It all depends on the cardinality of your data and a lot more things. That means that what in theory could improve performance, maybe doesn't. For example, I might be trying to optimize your query for records who have an integer value, but in the actual data they are all in zero (0).

If you were using select statements instead of xBAse commands, you could analyze the Rushmore optimization by using Sys(3054). Maybe you can give it a try.

Best luck,