✏️ Explanatory Question

When is using a View the best choice in reports?

👁 2 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Use a View when:

  • The report requires complex joins

  • Data is read-only

  • Aggregations or calculated fields are needed

  • The same logic is shared across multiple reports

  • You want better performance and maintainability