sqldoubleg - Sunday, March 26, 2017 3:33 AM
EXACTLY! The table is renamed to something else and the view is given the table name. The "Instead of" triggers are used to make it all work seamlessly for Inserts, Updates, and Deletes as if it were a single table rather than a multi-table view and it all requires precisely ZERO changes to the application. Being a "pass-through" view, Selects enjoy all of the benefits of the underlying indexes on the tables, as well.
Change is inevitable... Change for the better is not.
Viewing post 31 (of 30 total)