Kbase P73039: Query performance drops when using NOT operator in WHERE clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/14/2004 |
|
Status: Unverified
SYMPTOM(s):
Query performance drops when using NOT operator in WHERE clause
CAUSE:
This is expected behavior. The NOT operator will force a full Table Scan.
FIX:
Using the the = operator will force index use.