[sqlite] Join execution doubt

Hi! I'm studying the join execution... suppose a join with two tables without indexes.. is there any case at all where join will do a complete inner loop for each line in the outer loop? Because it seems it always build a temp table to autoindex the inner table.. thanks!

Re: [sqlite] 1.0.71.0 and VB 2008 Express Edition - SQLite.Interop.dll cannot be found

Thank you so much. It works again perfectly now :) Regards, Cyrille Le 07/05/2011 09:53, Kevin Benson a écrit : > On Sat, May 7, 2011 at 3:12 AM, Cyrille wrote: > >> Dear all, >> >> Sorry to send again my previous email (cf. below) but as I did not >> receive any answer, I

Re: [sqlite] Query question

On Fri, 6 May 2011, Matthew Jones wrote: > sqlite> create table a (a, b); > sqlite> insert into a values (10, 1); > sqlite> insert into a values (10, 2); > sqlite> insert into a values (10, 2); > sqlite> insert into a values (11, 2); > sqlite> insert into a values (11, 2); > sqlite> insert into a

Re: [sqlite] 1.0.71.0 and VB 2008 Express Edition - SQLite.Interop.dll cannot be found

On Sat, May 7, 2011 at 3:12 AM, Cyrille wrote: > Dear all, > > Sorry to send again my previous email (cf. below) but as I did not > receive any answer, I am wondering if my question was stupid or if > nobody could help me. Thank you very much in advance for your kind answers >

Re: [sqlite] 1.0.71.0 and VB 2008 Express Edition - SQLite.Interop.dll cannot be found

Dear all, Sorry to send again my previous email (cf. below) but as I did not receive any answer, I am wondering if my question was stupid or if nobody could help me. Thank you very much in advance for your kind answers Regards, Cyrille Le 30/04/2011 19:59, Cyrille a écrit : > > Dear all, > >