General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
A former programmer at my company had applied an alltrim to an indexed field. When I removed the alltrim the report that uses the field ran several times faster. This alltrim seemingly nullified the index on the field. Is there any explaination to this?
Thanks for all replies.
Mike
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