>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

Sunny

Are you doing the inserts within a begin - end transaction, or not doing TableUpdate() between inserts? This can lead to problems.