What's the benefit of using the SQLite Union Virtual Table over creating a view with unions? -


the sqlite authors implemented union virtual table, dont understand benefit of using on simple: create view foo select * a.foo union select * b.foo? wouldn't latter preserve index queries on tables , allow adding write functionality via triggers?


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -