Thoughts on creating index on LAST_UPDATE_DATE of INV.MTL_MATERIAL_TRANSACTIONS
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');