>>>You should make sure that all indexes for a table are stored with the table in a compound index file (cdx).
>>>
>>>Can you post the SQL that defines your view?
>>
>>
>>
>>This is it, generated by VFP
>>
>>
>>SELECT Pyoutbak.int06, Pyoutbak.c40_01, Tlkppaf.name, Pyoutbak.date01,;
>> Pyoutbak.datm06;
>> FROM sys2core!pyoutbak LEFT OUTER JOIN sys2core!tlkppaf ;
>> ON Pyoutbak.int01 = Tlkppaf.int01;
>> WHERE Pyoutbak.int06 <> 0;
>> AND TTOD(Pyoutbak.datm06) >= ?gd_start;
>> AND TTOD(Pyoutbak.datm06) <= ?gd_end;
>> ORDER BY Pyoutbak.datm06
>>
>>VFP created the index on the root_ directory of the server if that means anything.
>>
>>
>>CG
>
>
>What command did you issue to create the index? Either way, you should open the table exclusive, issue a DELETE TAG ALL. To make the above view optimizable, you want to:
>
>INDEX ON int01 TAG int01
>INDEX ON int06 TAG int06
>INDEX ON TTOD(datm06) TAG datm06


I did it in table properties. VFP placed the cdx on the servers root_ drive.
Should I move the indexes? The view is unuseable and there are only 3200 records.

Its a good fast server connection, too.

CG