ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: re Rebuilding Indexes in Oracle Apps -- Quoting an Apps
Richard,
Quoting Metalink Note 182699.1 on bde_rebuild.sql - Validates and
Rebuilds Fragmentated Indexes (8.0-9.0)
Index fragmentation occurs when a key value changes
Richard,
Quoting Metalink Note 182699.1 on
bde_rebuild.sql -
Validates and
Rebuilds Fragmentated Indexes
(8.0-9.0)
Index fragmentation occurs when a key value changes, and the index row is
deleted from one place (Leaf Block) and inserted into
another.
Deleted Leaf Rows are not reused.
Hemant,
It is absolutely true with Oracle Financials Databases and I have seen
performance degradation when indexes on such databses are not rebuilt at a
regular interval meaning indexes on certain tables on mothly basis.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of