How can we create index Faster(tables size is 4GB)?
Kindly assist here, Thanks in advance.
No Comments Posted for this Article.
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...
Indexes in SAP
Indexes - What are they and how to use?An index helps to speed up selection from the database. An index is a sorted copy of selected database table fields.Primary index:When you activate the table...