Execution Plan Intrepretation
Hi,
Please help me interpret the execution plan. Are we seeing multiple plans here? I see two PHV. Which among the plan is the best?
SQL
SELECT a.application_id,a.candidate_id,a.email,a.firstname,CASE WHEN ( a.date_apply_conf_sent is null and a.confirmation_email = 1 ) THEN 1 ELSE 0 END AS
send_confirmation_email,CASE WHEN (a.date_apply_return_sent IS NULL AND v.application_email IS NOT NULL AND sl.application_email_send = 1) THEN 1
ELSE 0 END AS send_return_email,v.vacancy_id,v.position_title,v.reference,v.hiring_manager_id,v.application_email,c.company_name,c.company_id,sl.application_email_type_id
Please help me interpret the execution plan. Are we seeing multiple plans here? I see two PHV. Which among the plan is the best?
SQL
SELECT a.application_id,a.candidate_id,a.email,a.firstname,CASE WHEN ( a.date_apply_conf_sent is null and a.confirmation_email = 1 ) THEN 1 ELSE 0 END AS
send_confirmation_email,CASE WHEN (a.date_apply_return_sent IS NULL AND v.application_email IS NOT NULL AND sl.application_email_send = 1) THEN 1
ELSE 0 END AS send_return_email,v.vacancy_id,v.position_title,v.reference,v.hiring_manager_id,v.application_email,c.company_name,c.company_id,sl.application_email_type_id
0