Hello;
Do views and tables have different performance characteristics?
Or, is their only purpose to provide multi-table data sets?
Consider these two scenarios:
tbl_1 -> fld_1 | fld_2 | fld_3 | fld_4 | fld_5 | fld_6
frm_1 -> tbl_1.fld_3 | tbl_1.fld_5
Will the following View save me data usage or speed up the call? (or do anything else)
view_1 -> tbl_1.fld_3 | tbl_1.fld_5
----------------------------------------------------------------------------
frm_2 - tbl_1.fld_1 | tbl_1.fld_2 | tbl_1.fld_3 | tbl_1.fld_4 | tbl_1.fld_5 | tbl_1.fl