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;