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
You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a large result
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!