We Are Running Win 2003, Oracle 9i, Sap 4.7. We Are Having Performanc

1.	We Are Running Win 2003, Oracle 9i, Sap 4.7. We Are Having Performance Issues Around Tx Miro Which Updates Table Rbkp. Table Rbkp Has Five Indexes In Sap, But Only Three Of Which Exist In Oracle. Why Is This?
Answer» In SAP there are many PREDEFINED indexes. You can see these indexes via DB02->checks-> database ->ABAP DICTIONARY ->DISPLAY. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level. In SAP there are many predefined indexes. You can see these indexes via DB02->checks-> database ->ABAP dictionary ->display. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.

We Are Running Win 2003, Oracle 9i, Sap 4.7. We Are Having Performance Issues Around Tx Miro Which Updates Table Rbkp. Table Rbkp Has Five Indexes In Sap, But Only Three Of Which Exist In Oracle. Why Is This?

Answer»

In SAP there are many PREDEFINED indexes.
You can see these indexes via DB02->checks-> database ->ABAP DICTIONARY ->DISPLAY. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.

In SAP there are many predefined indexes.
You can see these indexes via DB02->checks-> database ->ABAP dictionary ->display. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.

Discussion

No Comment Found

Related InterviewSolutions

Is There A Way To Perform Sapgui 640 Roll Out Using A Centralized Server?
If Sapconsole Telnet Screen Size Is Too Big How Do You Make It Smaller?
In Our Dev System We Have Opened The Client With All Options "changed Without Automatic Rec," "changes To Repository And Cross Customization Allowed," And "protection Level-0 No Restriction" In Scc4. The Developers Complain That They Get An Error Message Saying The System Is Non-modifiable. What Should We Do To Fix This?
I'm Trying To Send Email From Sap To Microsoft Outlook. When I Attempted To Configure Sapconnect It Failed. On Unix Level I Try To Run Command "mlunxsnd" And "mlosmadm" But Found That It Doesn't Exist In Unix. How Should I Solve This Problem?
I Want To Let Sap Skip Printing Cover Pages During Printing For Any Kind Of Report. How Can This Be Done?
Is There A Way To Find Out What Was Entered In A Particular Transaction Code Screen?
I Need To Schedule A Background Job To Run For 3 Consecutive Days And Would Like To Use Db13. How Can I Schedule A Report To Run From Db13 And Not Sm37?
When I Release All Of The Requests To Dev It Is Not Being Displayed In An Import Queue On The Qa System (t-code Stms). When I Check The Log Of Transport Request Overall Status Is Successful, But A Message Appears Saying "continue: Other Transport Group." Why Is This Message Appearing?
We Have A J2ee + Abap 6.40 Instance Running A Portal 6.0. It Seems 1gb Of Memory Is Not Enough And J2ee Has Problems If We Assign More. What Can Be Used To Balance The Load In The Servers?
After A Recent Upgrade Of Kernel 6.20 To 6.40, While Doing A Transport I Received Several Warning Parameters Although Everything Looked Okay On Sap T-code Stms, What Should I Do About The Warning Parameters.