Monday, August 15, 2016

INDEX


Created index:
CREATE INDEX SAPEBP.”CDHDR~VRS” ON SAPEBP.CDHDR (MANDANT, USERNAME, UDATE) TABLESPACE “PSAPEBP” parallel 8 online;
Index rebuild:
alter index SAPEWD.”/BIC/B0001951000~0″ rebuild online;
RSANAORA —- TO REBUILD THE INDEX
RSORATAD —- Check index performance. if it is less than 50% den we need rebuild the index.
To check data file size in database
SQL>select substr(name,1,45),bytes/1024/1024/1024 from v$datafile;
to change parameter in spfile
SQL>alter system set processes=100 scope=spfile;
SQL>create pfile from spfile;
sql>alter database create datafile ‘/oracle/DCP/sapdata3/dcp_34/dcp.data34’;
Analysis of Index storage quality
Table:                      HRP1001
Index:                      HRP1001~0
Owner:                      SAPSR3
Space per block:                   byte          8.033
Space per index entry:             byte          68,29
Number of table rows:                            30.260
Number of blocks (calc.):                        298
Number of blocks (alloc.):                       384
Number of blocks in freelists / groups:          0 /  0
Number of blocks (used):                         384
Index storage quality:                %          78

1 comment: