Inventory Management - EBS (MOSC)

MOSC Banner

Thoughts on creating index on LAST_UPDATE_DATE of INV.MTL_MATERIAL_TRANSACTIONS

edited May 18, 2016 5:08AM in Inventory Management - EBS (MOSC) 1 commentAnswered

This is one of our larger tables.  When BI queriers run they would be helped by an INDEX on LAST_UPDATE_DATE. What should we test to make sure EBS is not negatively affected by this new index?

This is what I would run on the dbTier.

CREATE INDEX INV.XXMTL_MATERIAL_TRANSACTIONS_N2 ON INV.MTL_MATREIAL_TRANSACTIONS(LAST_UPDATE_DATE);

EXECUTE DBMS_STATS.GATHER_INDEX_STATS('INV', 'XXMTL_MATERIAL_TRANSACTIONS_N2');

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center