Well,

The initial query is:

Select a.field1 As Code, a.Field2 As Desc From TableA a Into Cursor tmpCursor

The table has an index on field1 so I added:

where a.Field1 = ""

It's a cheat I know but the query is optimised and works as long as set exact off.

The time jumps from 5 secs to under 2.

Regards
>>Hi Mike,
>>
>>Yes I can and I have by introducing a dummy where clause. It optimises and halves the time roughly 2 seconds.
>>
>
>Hi Mathias,
>
>Can you expand a little on this "dummy where clause" idea?
>
>Regards,