Are indexes in Locally Managed Segment Space Management Auto perform worse than those in Tablespace
Hi Gurus,
My environment is OS: HP UNIX PARISC, Oracle EE 10.2.0.4. We migrated from 8i and have lots of locally manged[Manual] Tablespaces.
I am in testing phase. We have some tables that have lots of deletions taking place. On those tables we have huge number
of indexes and their structure has became so bad, needs recreation. Recreated tables usinga as select * from table to
table_tmp in locally managed Auto Segment Space Management tablespaces. The idea is to use COMPACT and SHRINK in future
to released unused space. On the same lines indexes were also recreated from locally manged [Manual] to locally managed
0