A dashboard should repeatedly read a stored result of an expensive aggregate query that is refreshed through a managed process. Which object fits this requirement?

Published
  1. An ordinary view with no materialization
  2. A session-scoped temporary scalar variable
  3. A one-time result copied into a text widget
  4. A materialized view

Comments — 0