Kbase P59712: SQL-92: Why using UPPER or LOWER function in WHERE clause decreases performance?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
SQL-92: Why using UPPER or LOWER function in WHERE clause decreases performance?
FACT(s) (Environment):
Progress 9.x
FIX:
According to SQL-92 standard indexes are case-sentive and therefore index cannot be used with UPPER/LOWER or UCASE/LCASE functions.
For example, the statement "select * from pub.customer UCASE(name) = UCASE('Hoops')" does a full table scan even though name is an index field.