subject:"\[sqlite\] IN verses EXISTS Query Speed"

Re: [sqlite] IN verses EXISTS Query Speed

2016-10-16 Thread Keith Medcalf

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Dave Blake > Sent: Sunday, 16 October, 2016 00:58 > To: SQLite mailing list > Subject: [sqlite] IN verses EXISTS Query Speed > > Some simple testing is showing using an EXISTS statement is generally > quicker then using an IN >

Re: [sqlite] IN verses EXISTS Query Speed

2016-10-16 Thread Clemens Ladisch

Dave Blake wrote: > SELECT * FROM tablea > WHERE EXISTS (SELECT 1 FROM tableb WHERE tablea.id = tableb.id AND ...) > > is quicker than > SELECT * FROM tablea > WHERE tablea.id IN (SELECT tableb.id FROM tableb WHERE ...) > > Is there any reason for this to be always true in SQLite, or is it query

[sqlite] IN verses EXISTS Query Speed

2016-10-15 Thread Dave Blake

Some simple testing is showing using an EXISTS statement is generally quicker then using an IN e.g. SELECT * FROM tablea WHERE EXISTS (SELECT 1 FROM tableb WHERE tablea.id = tableb.id AND ...) is quicker than SELECT * FROM tablea WHERE tablea.id IN (SELECT tableb.id FROM tableb WHERE ...) Is