>>Remove the alias from the WHERE clause. I have seen this slow queries down. Also, what does SYS(3054) report for optimization levels?
>
>Larry,
>
>Removing the alias made a marginal difference and I'm not sure if I'm using the SYS(3054) correctly. It reports that the table has no optimization. Reading the help I'm under the impression that it should report something else regarding the query.
>
>Renoir

If it's reporting no optimization, there the tag you say you have on FileType isn't being used. Is it possible that your tag is on UPPER(FileType)?

Tamar