General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only