View: dbo.Bank_Transaction_Denormalized_View | |||
View definition | |||
--Bank_Transaction_Denormalized_View can be used to improve queries. --This allows a join to be skipped in many cases and also allows --for simplified query plans. Both of these contribute toward --faster running queries. --This was initially added to improve PayrollEmployeeTaxItemDataSource, but --this could eventually be used in expressions in general. CREATE VIEW dbo.Bank_Transaction_Denormalized_View WITH SCHEMABINDING AS SELECT bt.bank_transaction_KEY , bt.transaction_date , bt.checkbook_KEY , c.client_KEY FROM dbo.Bank_Transaction AS bt INNER JOIN dbo.Checkbook AS c ON c.checkbook_KEY = bt.checkbook_KEY; | |||