Thanks Sergy,
...
>>Hi,
>>
>>When using insert command to add record in table its not updating index file. I am not opening table before passing insert command. Is any way to update index file with inser command?
>>
>>TIA,
>
>Use structural compound index. It's open automaticaly any time a table is open. There's how it can be created.

USE mytable EXCLUSIVE
>INDEX ON filed1 TAG filed1 ADDITIVE
>INDEX ON filed2 TAG filed2 ADDITIVE
>INDEX ON filed3+filed4 TAG f3_f4 ADDITIVE