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