KCAE.INDEX:3 - Forces
Prepared views reduce recurring work but cost construction and refresh. Several views increase discovery opportunities and duplicate results. Early filtering saves work and can exclude the unknown answer. Rich context improves interpretation but lowers the number of candidates that fit a fixed budget. Choose the arrangement for its usefulness and maintenance cost on this workload.