Kbase P8589: Why perfomance decreases when using = instead of BEGINS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2003 |
|
Status: Unverified
GOAL:
Why performance decreases when comparing using EQ = instead of BEGINS
FIX:
BEGINS uses indexes whenever is possible (and consequently uses collation tables if an index is used)
EQ or =: The current collation table is used to compare characters in an equality test. This is because in some codepages (and some languages) different characters may actually be considered equals. As an example, capital A and capital A-accent are considered to be equal in the ISO8859-1 codepage.