I have a view that combine several tables, so that the view presents more information that each table taken individually. I want to write an "INSERT INTO ... SELECT ... FROM xxx" query. Should I use the View in that "FROM xxx" or should I expand what the view shows? What's better in terms of optimization and/or business practice?
(I run on MySQL if it makes any difference)
September 8, 2011 3:38 PM
March 31, 2012 4:58 PM