May I know will there be any impact if I do Alter index indexname shrink space In production ?
Do I need to rebuild the index post shrink operation ?
Please share your views.
Thanks in advance.
No Comments Posted for this Article.
Oracle Index Organized Tables (IOTs)
1. What is an Index Organized Table (IOT)?An Index Organized Table (IOT) is a table that is sorted internally as an index.Other database systems such as MAXDB or DB2 use IOTs by default, whereas on...
Partitioned Indexes Just like partitioned tables, partitioned indexes improve manageability, availability, performance, and scalability. They can either be partitioned independently (global indexes)...
SAP Oracle Missing Indexes
Identify the missing indexes in DB02 (which will reduce the performance without proper indexes) Goto DB02 > Diagnostics > Missing Tables and Index Check the objects that are missing ...
Rebuilding Indexes in SAP
1. How do we find out the indexes that are to be rebuild? You can use sapdba --> reorganization --> check extents and fragmentation.2. Is there any tcode available in SAP to rebuild indexes or...