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; | |||