Glossary

With COLCARDF = 1095 (inflated):

FF for `TRAN_DATE = :WS-PROCESS-DATE`: 1/1095 = 0.000913 - FF for `ACCT_STATUS IN ('A', 'P', 'H')`: 3/6 = 0.50 - Combined FF: 0.000913 * 0.50 = 0.000457 - Estimated rows from DAILY_TRANSACTIONS: 500,000,000 * 0.000457 = 228,500 - But the optimizer compared this against the tablespace scan cost...

Learn More

Related Terms