resultset/how to use index table to seach the record

[Eung maeng]

Hi Guru,
Would anyone be able to answer for my question urgently? Regarding the search the record fastly from secondary table.
I'm using the resultset to check whether the record is exit in secondary table from main table like chain to the secondary table.
I'm really stuck here.
If I need to create the index table, how do I use it in the program?
Actually, my program use the phigical table to chain from the record on Main table. It's so slow to chain the secondary table now.

Please anyone help me in this matter by mail
It would be appreciated.
cheers,
Paul Maeng
[e-mail]