Hello Ulrich,
> I don't know wether it's faster, but try
>
> select a,b,c from d where c in (select c from d except select
> c from e)
Sorry to say but this made no difference :-(
I'll try my method next...
Thanks for your help,
David Carter-Hitchin.
--
Royal Bank of Scotland
Interest Rate
Hi Ulrich and Jay S.
> I don't know wether it's faster, but try
>
> select a,b,c from d where c in (select c from d except select
> c from e)
>
> Maybe you're lucky and it's faster.
Thanks - I'll give IN a go, instead of NOT IN
Cheers,
David Carter-Hitchin.
--
Royal Bank of Scotland
t;
> David Carter-Hitchin.
> --
> Royal Bank of Scotland
> Interest Rate Derivatives IT
> 135 Bishopsgate
> LONDON EC2M 3TP
>
> Tel: +44 (0) 207 085 1088
>
> > -Original Message-
> > From: Brett Wilson [mailto:[EMAIL PROTECTED]
> > Sent: 14 March 2006 16
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?
Bishopsgate
LONDON EC2M 3TP
Tel: +44 (0) 207 085 1088
> -Original Message-
> From: Brett Wilson [mailto:[EMAIL PROTECTED]
> Sent: 14 March 2006 16:48
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Help needed to diagnose "NOT IN" query
>
>
> Davi
David,
I asked a similar question, and here is drh's response to me, adapted
to your situation. I think it is probably applicable to you as well.
I'm not sure this is the type of query that can be made to go really
fast no matter what. I actually haven't gotten around to doing this
yet, so I
6 matches
Mail list logo