Hi Christian,
You want to index on the fields or combination of fields that the query will be run against. Try different indexes and use SYS(3054) to see how well they are being optimized.
>HI John,
>It is local. My pk is a NUMBER type field and I indexed it. My FK is also a number and it is also indexed.
>
>Thank you for your help,
>Christian Cote
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05