>>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
Erik Moore
Clientelligence