>I have a view of a database that is taking almost 2 minutes to complete. I copied the SQL, modified it, and am using the resulting statement below to test with.
>
>I am only selecting 93,794 out of 141,642 records on a table (belongs to a database) on a local drive. It still is taking between 30 seconds and 1 minute to complete. There are already various indexes on the base table and one specifically for FileType. I have reindexed everything, validated the database and done everything I know to do. Why would this take so long to run? Thanks!
>
>

>SELECT * FROM data\Employee.dbf WHERE Employee.filetype = "EMPLOYEE"
>

>
>Regards, Renoir

Hi Renoir,

Note how long will take to do

SELECT * FROM data\Employee.dbf INTO CURSOR temp NOFILTER

Multiply that time by .7 ( 70% records you extract with your query). That should give you an estimate of the min time your query could take.