Changes between Version 3 and Version 4 of QueryOptimization

Timestamp:

09/15/26 11:48:23 (10 days ago)

Author:

231039

Comment:

--

QueryOptimization

@@ -3 +3 @@
 = Views =
 
-* View 1: daily_clinic_schedule
-* View 2: pet_medical_history
-* View 3: active_prescriptions_for_pet
-* View 4: employee_performance_summary
+* View 1: daily_clinic_schedule - indexed
+* View 2: pet_medical_history - indexed
+* View 3: active_prescriptions_for_pet - indexed
+* View 4: employee_performance_summary - materialized
 * View 5: invoice_billing_details
 * View 6: low_stock_shop_items
@@ -27 +27 @@
 * idx_shop_item_category_name on shop_item_category(name)
 
+To improve performance even further, the view employee_performance_summary is materialized.
+
 Detailed documentation:
 [https://develop.finki.ukim.mk/projects/pawcare/attachment/wiki/QueryOptimization/PawCare_Views_Indexes_Documentation.docx]