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

Reply via email to