[sqlite] inner joins on prepared statements

Hello All,

                Say I have the following prepared statement "select
B.foo from A inner join B on A.bar = B.bar where A.foo = ?" used to
populate values from a reference table.  If I intend on executing this
statement several times with different bound values,  is it better for
me to generate a temporary table to remove the inner join or will SQLite
internally keep a temporary table  for this statement?

 

-Shaun

 

 

 

 

_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users