Kbase P3381: Performance difference between 'logical NOT VALUE' and 'logical = VALUE'
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Performance difference between 'logical NOT VALUE' and 'logical = VALUE'
This:
for each TABLE where NOT F2
takes longer than:
for each TABLE where F2 = NO
CAUSE:
The first piece of code is not an active equality match so the table is scanned rather than using the index
FIX:
No real fix, expected behaviour