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

Full Data Access

To access all of the data for an account, you need a version of the previous query without the date range predicate.

SELECT {columns}
FROM ACCT_HIST HIST
INNER JOIN
     ACCT_HIST_DATES DTE
ON HIST.HIST_EFF_DTE = DTE.EFF_DTE
WHERE HIST.ACCT_ID = :ACCT-ID;