>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