Evaluate index for security_policies and approval_policy_rules

The following discussion from !160718 (merged) should be addressed:

  • @sashi_kumar started a discussion: (+3 comments)

    note This will generate the query:

    SELECT
        "approval_policy_rules".* 
    FROM
        "approval_policy_rules" 
    INNER JOIN
        "security_policies" "security_policy" 
            ON "security_policy"."id" = "approval_policy_rules"."security_policy_id" 
    WHERE
        "approval_policy_rules"."rule_index" = 0 
        AND "security_policy"."security_orchestration_policy_configuration_id" = 63 
        AND "security_policy"."policy_index" = 0

    Since we don't have any rows in security_policies, the query plan would not be accurate.