My Oracle Support Banner

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:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.


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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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