Q1. A DBA creates a view joining three large tables to simplify reporting. Reports using the view run very slowly, impacting business decisions. The DBA wants to improve performance without altering the base tables. Which approach is best?

• ○Create a materialized view to store the join results and refresh it periodically.
• ○Add indexes on all columns used in the view's joins and filters.
• ○Rewrite the view as a recursive CTE to optimize hierarchical joins.
• ○Grant SELECT permissions on the base tables directly to reporting users.