Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order of executionplan and the Variations after index creation

SGUApr 24 2020 — edited May 21 2020

Dear Jonathan

Attached the current plan and the sql for your reference.Can you please let us know the order of the plan and if possible how can force the index on 40/41

From plan,we could see the new index used on step 43 thereby eliminating the filter.

43 - access("ACT2"."APPLICANT_ID"=:B1 AND "STATUS_FLAG"='C')

We would like to achieve the same index on steps 40/41.Please suggest.

Thank You

This post has been answered by Jonathan Lewis on May 14 2020

Jump to Answer

Added on Apr 24 2020

#general-database-discussions

18 comments

876 views