DB_EXECUTE_SQL

[Former Member]

Hello,

We got a advise from SAP to perform the following activity:

____________________________________________

My Question is: Is it done by the BASIS or ABAPer? 

Should the below STATS applied daily or how is it ?

Should that be applied in each systems ?

_____________________________________________

How to adjust the statistics to increase distinct keys on index AFKO~4:

1. Call SE37
2. Enter DB_EXECUTE_SQL and hit F8
3. Enter the following:
begin
DBMS_STATS.SET_INDEX_STATS(user,'"AFKO~4"',NUMDIST=>500,NO_INVALIDATE=>FALSE); end;

4. Press F8 on your keyboard to execute.
The statistics would then need to be frozen so they are not
overwritten by subsequent statistic executions. You would do this as
follows:

DELETE FROM DBSTATC WHERE DBOBJ = 'AFKO';
INSERT INTO DBSTATC (DBOBJ, DOTYP, VWTYP, ACTIV) VALUES
('AFKO','01','O','R');
INSERT INTO DBSTATC (DBOBJ, DOTYP, OBJOW, OBJEC, VWTYP, ACTIV) VALUES
('AFKO','ID','AFKO~4','500','O','A');
COMMIT;

[fidel_vales · Accepted solution]

Hello,

That can be done by BASIS or by can be executed directly at DB level by the DBAs;