Why the Explain Plan Is Different and Not Using the 'TABLE ACCESS STORAGE FULL TABLE HR.PAY_PEOPLE_GROUPS' Index when Executing a Query On Different Environments? (Doc ID 3035904.1)

Last updated on JULY 24, 2024

Applies to:

Goal

Why the Explain Plan is different and not using the 'TABLE ACCESS STORAGE FULL TABLE HR.PAY_PEOPLE_GROUPS' index when executing a query on different environments?

For example:

SELECT *
FROM per_all_assignments_f paaf, pay_people_groups ppg
WHERE paaf.people_group_id = ppg.people_group_id(+) AND paaf.person_id = <:person_id> AND paaf.assignment_id = <:assignment_id>;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.