Skip to Main Content
Forums

SQL & PL/SQL

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!

Invisible Indexes

Aj09Jul 11 2013 — edited Oct 7 2013

Oracle DB 11g Enterprise Edition

Release 11.2.0.3.0 - 64bit

Folks,

We have a job for which we created Invisible indexes. We use the ALTER SESSSION SET OPTIMIZER_USE_INVISIBLE_INDEXES = TRUE;  Howerver our job is still not picking the indexes.

The Job is run as a People Soft Process. We have tried other session commands in the past and they have been working fine. Other than using /*+ index(table index)  */ HINT is there another way to make sure invisible indexes are used.

Thank you

Aj
This post has been answered by davidp 2 on Oct 7 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2013
Added on Jul 11 2013
3 comments
737 views