On 3/15/06, CARTER-HITCHIN, David, FM <[EMAIL PROTECTED]> wrote: > Hi Brett, > > Many thanks for replying. Well I tried PRAGMA temp_store=memory and that > sadly did not help. >
I believe the 'not in' does not use indexes, but 'in' does. Can you flip your logic?