>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
Renoir,
You may want to have the table already opened and/or limit the fields that are retrieved.
Doug