So if I build a view that includes look-ups in other tables, the
optimizer may skip these at places where not selected. However only if
the look-ups are written as outer joins. Then it may be good practice
allways doing that. For instance:
create view vtrack as
select trackname, artistname
from track
left join artist ON trackartist=artistid -- note left join
;
~
~
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
