[sqlite] Newbie question, how multiple joins are executed

Hi! I understand that for a query with a two tables join, SQLite will do a nested loop join with these two tables. But what about a query joining 5 tables? It would be like this?: for(table1 lines){ for(table2 lines){ for(table3 lines){ Thanks.

[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!

[sqlite] Help with the code: vdbe

Hi!! I'm studying databases in my college and I'd like to implement an algorithm to SQLite... since I'm not familiar with C, could you guys help me a little? For now, I just need to, every time the VDBE enters in OP_COLUMN, get the column value and put it to a string variable, that's all ! Thank

[sqlite] Newbie question

Hi! Are primary keys and foreign keys indexes by default? Or do we have to set them as indexes? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users