Thanks Terry
The where clause is purely for selection criteria. Not joining tables.
>Mathias
>
>Sounds reasonable. I would recommend that where poss. you use the join conditions in your SQL (e.g. "inner join OtherTable on ...", rather than "where ...". It can speed up your queries by an order of magnitude.
>
>HTH
>
>Terry
>
>>Hi All,
>>
>>I have had reports and a colleague has confirmed that a query takes significantly longer if the table being queried is open shared so:
>>
>>Select a.* from Customer a Into Cursor curCustomer where ??? && takes 2 seconds when I am the only user in the system
>>
>>The same query takes 5 seconds if the table customer is open by another user.
>>
>>No views involved
>>
>>Any ideas please?
Mathias Banda
Time is longer than a rope.