In reviewing this thread, it appears that you never got your query to use Rushmore optimization. I strongly suggest you check the exact index expression and make sure you use that in your query. If your index is on UPPER(EMPLOYEE) then use that. If it's on ALLTRIM(EMPLOYEE) then use that - or alter the index to match your SQL statement if that doesn't break other things.

Even though you've used a second view or query to speed up things, it should speed things up quite a bit to properly optimize them....

FWIW

>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