Kbase P26272: SQL92 query that has an expression in the where clause cause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2003 |
|
Status: Unverified
SYMPTOM(s):
SQL92 query that has an expression in the where clause causes a table scan where the same constant value does an index scan
CAUSE:
SQL92 doesn't support the use of an expression in the where clause
FIX:
Use a value not an expression