Database Tuning (MOSC)

MOSC Banner

How can I use invisible index in spm?

in Database Tuning (MOSC) 3 commentsAnswered

Hello!

I need to use invisible index without making it visible or using hint or set optimizer_use_invisible_indexes=true. I have captured the plan by setting optimizer_use_invisible_indexes=true in dba_sql_plan_baselines and set fixed, enabled, accepted to 'YES'. But when I set optimizer_use_invisible_indexes=false that plan is not used by the query. How can I force optimizer to use that plan?

I am using 12.2.0.1.0 on RHEL 7.4

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center