>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"
>
>
Renoir,
Remove the alias from the WHERE clause. I have seen this slow queries down. Also, what does SYS(3054) report for optimization levels?
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao