Witte
Marauder
- Joined
- May 21, 2005
- Posts
- 5,713
- Society
- Delta Force Elite
- Avatar Name
- Vlugge Witte Harrie
In the meanwhile I made some progress. It seems that when I replace "Chart!='Chart'" with "Chart NOT LIKE 'Chart'" the issue is solved. The query time reduces from 2.8s to 1ms.
I have absolutely no idea why but maybe to someone else this information is useful. If I do not find the cause of the problem my next course of action will be replacing all instances of "!=" with "NOT LIKE".
I have absolutely no idea why but maybe to someone else this information is useful. If I do not find the cause of the problem my next course of action will be replacing all instances of "!=" with "NOT LIKE".