Changes between Version 3 and Version 4 of QueryOptimization

Timestamp:

07/01/26 18:13:18 (4 days ago)

Author:

231082

Comment:

--

QueryOptimization

@@ -93 +93 @@
 RETURNS TABLE (...) LANGUAGE plpgsql STABLE AS $$
 BEGIN
-RETURN QUERY
-WITH active_pe AS (
--- Only one row due to student_id filter pushed down
-SELECT pe.id AS pe_id, pe.academic_program_code
-FROM Program_Enrollment pe
-WHERE pe.student_id = p_student_id
-AND pe.date_disenrollment IS NULL
-AND pe.finished IS NOT TRUE
+  RETURN QUERY
+  WITH active_pe AS (
+  -- Only one row due to student_id filter pushed down
+  SELECT pe.id AS pe_id, pe.academic_program_code
+  FROM Program_Enrollment pe
+  WHERE pe.student_id = p_student_id
+  AND pe.date_disenrollment IS NULL
+  AND pe.finished IS NOT TRUE
 ),
 -- All subsequent CTEs now operate on one student's data