Glossary

With COLCARDF = 365 (correct):

FF for `TRAN_DATE = :WS-PROCESS-DATE`: 1/365 = 0.00274 - FF for `ACCT_STATUS IN ('A', 'P', 'H')`: 3/6 = 0.50 - Combined FF: 0.00274 * 0.50 = 0.00137 - Estimated rows from DAILY_TRANSACTIONS: 500,000,000 * 0.00137 = 685,000 - Index access cost (MATCHCOLS=4, CLUSTERRATIO=95%): mostly sequential I/O -

Learn More

Related Terms