General information
Category:
Coding, syntax & commands
If I put in WHERE clause an expression like UPPER(field_name) = UPPER(var_char) and my index is not UPPER(field_name) then I won't get the Rushmore optimization at all. Thus, data retrieval would be a slow process. I have tried SYS(3054,1) to check the level of optimization and there is no optimization if WHERE and INDEX expressions don't match.
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