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" = 0Since we don't have any rows in
security_policies, the query plan would not be accurate.