Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Nadya
>I agree with you, but yesterday we discovered some really nasty indexes like ALLTRIM(UPPER(c_lName)) with FOR conditions.
I see nothing particularly nasty there. UPPER(ALLTRIM()) is supposed to be faster because there are less characters to upper. The FOR conditions automatically suppress Rushmore, but if the code is using seeks for everything, then you'll definitely be breaking stuff.
Previous
Next
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