I didn't tell her to use INNER JOIN, just use '=' instead. and It can make a difference.

Bye
Jayesh

>Jayesh,
>You CC to me and I reply. She already told it has been tried and even slower (inner join).
>Cetin
>
>>Hi Diana,
>>
>> Why don't you use simple WHERE condition like
>>Clients.nclient_id = charge_visits.nclient_id
>>
>>Bye
>>Jayesh
>>
>>
>>>Howdy,
>>>I'm using VFP5.0a.
>>>
>>>I've got a view that looks like this: create sql view "lvclientcharges" as select trim(clast)+', '+trim(cfirst),csac_id,chosp_id,dbirth,dcontact,nclient_id from clients where nclient_id in (select nclient_id from charge_visits) order by clast,cfirst
>>>
>>>The Clients table has 49,000ish records and has indexes on the nclient_id and deleted() and cfirst and clast fields - to name a few. The Charge_visits table has 41,000ish records with indexes on nClient_id and deleted() also to name a few. This view takes at least 1 minute to run. I'd like to speed it up. Any ideas?
>>>
>>>I've tried just creating a view with an inner join on these two tables, but that's even slower...
>>>
>>>TIA