Designing Tables and Indexes for Performance › Table Designs for Special Situations › Building an Index on the Fly › Current Data Access

Current Data Access

Current data access is simple. You can retrieve the account history data directly from the account history table.

SELECT {columns}
FROM ACCT_HIST
WHERE ACCT_ID = :ACCT-ID
AND HIST_EFF_DTE = :HIST_EFF-DTE;