General information
Category:
Coding, syntax & commands
Randall,
It's best to avoid index expressions on character fields which return a variable length for the field value. ALLTRIM() will return a variable length.
Brien is suggesting that you take the ALLTRIM expression off and make sure that the fields on both sides of the ON expression are indexed for best performance.
Jay
>I'm little confused. Do you mean the actual index in both tables are ALLTRIM(companyid) or the index is on companyid?
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