If possible, work with no order set. (ie SET ORDER TO).

Vlad

>Hello,
>
>I'm using a form to browse and update a table with the
>fields: organisation, customer, ...
>
>On the form only records of one organisation should be
>displayed. The user is able to select the organisation
>with a command button. I have set a filter like this:
>organisation = '001'
>
>I have also an index on organisation to optimize the filter.
>But it is still very slow:
>
>e.g. Organisation '001' 150000 records
> Organisation '002' 250 records
>
>It seems that in the case of organisation '002' all records
>were read -> takes 70 seconds to move from the first to the
>last record.
>
>Without a filter it is quite fast.
>
>Any suggestions?
>
>Thanks in advance.
>
>Andreas