View: dbo.Direct_Deposit_Allocation_Performance_View
View definition
--This view allows for force seeks on the Direct_Deposit_Bank_Transaction_Allocation,
--Bank_Transaction_Reconciliation_Detail, and Ach_Company_Batch_Header_Record,
--this gives a performance improvement when loading the direct deposit list during the
--loading of the IBAR screen.
CREATE VIEW dbo.Direct_Deposit_Allocation_Performance_View
AS
SELECT
ddbta.ach_company_batch_header_record_KEY,
acbhr.ach_file_header_record_KEY,
btrd.amount,
btrd.bank_reconciliation_statement_KEY,
bt.bank_transaction_KEY,
btrd.bank_transaction_reconciliation_detail_KEY,
bt.bank_transaction_type_KEY,
bt.checkbook_KEY,
btrd.description,
ddbta.bank_transaction_KEY AS direct_deposit_bank_transaction_allocation_table__bank_transaction_key,
ddbta.direct_deposit_status_KEY,
afhr.file_creation_date,
afhr.physical_file_name,
bt.reference_number,
ddbta.direct_deposit_bank_transaction_allocation_KEY AS source__direct_deposit_bank_transaction_allocation_KEY,
bt.transaction_date,
bt.transaction_status_KEY
FROM dbo.Bank_Transaction_View bt
INNER JOIN dbo.Direct_Deposit_Bank_Transaction_Allocation ddbta WITH (FORCESEEK)
INNER JOIN dbo.Bank_Transaction_Reconciliation_Detail btrd WITH (FORCESEEK) ON ddbta.direct_deposit_bank_transaction_allocation_KEY = btrd.source__direct_deposit_bank_transaction_allocation_KEY ON bt.bank_transaction_KEY = btrd.bank_transaction_KEY
INNER JOIN dbo.Ach_Company_Batch_Header_Record acbhr WITH (FORCESEEK)
INNER JOIN dbo.Ach_File_Header_Record afhr ON acbhr.ach_file_header_record_KEY = afhr.ach_file_header_record_KEY ON ddbta.ach_company_batch_header_record_KEY = acbhr.ach_company_batch_header_record_KEY;