Hi all,
I have a question with seek and re-indexing if you have a moment.
I have this huge table, number of records generally are about say 500,000 or more and I want to search a name or account based on indexes defined.
I use the - select 0.. Use table.. set order to xxx, to open the table and use seek to find what I want to find.
It works fine, only after a certain number of inserts into the table, it sometimes(not consistent) does not find what I inserted until I reindex the table.
How can I improve my situation WITHOUT having to reindex?
Please advise.

Thanks!
Sunny