You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result
Posted: Thu Nov 10, 2022 6:44 am
You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result set after executing the Joins.
The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.
What should you use? (Choose the best answer.)
A. Table
B. View
C. Stored procedure
D. Materialized view
The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.
What should you use? (Choose the best answer.)
A. Table
B. View
C. Stored procedure
D. Materialized view