Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only