What is the Impact of the Use of a Custom Invisible Index on Table MTL_MATERIAL_TRANSACTIONS?
(Doc ID 2578916.1)
Last updated on SEPTEMBER 10, 2019
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
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