How can you determine the last refresh time of a materialized view?

• A. Check REFRESHED_ON and BEHIND_BY columns in the output of SHOW MATERIALIZED VIEWS
• B. Check CREATED_ON in the output of SHOW MATERIALIZED VIEWS
• C. Query INFORMATION_SCHEMA.MATERIALIZED_VIEWS
• D. Describe MATERIALIZED_VIEW

Answer: (A)

The last refresh time is provided directly in the SHOW MATERIALIZED VIEWS output. Look at the REFRESHED_ON timestamp—the value there is the exact time the materialized view was last refreshed. The BEHIND_BY column is also useful because it shows how far behind the latest data the view is, giving you a sense of currentness.

This approach is preferred because CREATED_ON only tells when the object was created, not when it was last refreshed. Querying INFORMATION_SCHEMA.MATERIALIZED_VIEWS or DESCRIBE MATERIALIZED_VIEW typically won’t yield the last refresh timestamp or the current staleness, so they don’t directly answer when the view was last refreshed.