What is the Impact of the Use of a Custom Invisible Index on Table MTL_MATERIAL_TRANSACTIONS? (Doc ID 2578916.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Goal

You have a custom program which uses the Descriptive Flexfields Attribute columns to search for transactions in the table MTL_MATERIAL_TRANSACTIONS.
You notice more and more of a degradation in the time taken to run the program.  You  tried various methods to increase performance without much
success  In researching solutions, you discovered a new 11g feature called an Invisible Index. You have created one and performance has
sufficiently improved.

Is there any major impact in using an Invisible Index?
 

Solution

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