on 04-13-2007 3:43 PM
hi
Brconnect shows messages:
Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.TESTDATRNRPART0
Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.TESTDATRNRPART1
.......
I run db02 -> missing index but nowher missing index not there!!
How to find that indexes?
regard's
Denis
with the table name you get, this looks like a temporary table created at database level, not in SAP level. to make sure, check SE11 if you see those table's definition.
Ask your colleagues if they know about this table.
If nobody knows about it, consider exporting their contents and then drop those tables... if someone complains, you will find the culprit and will still have the contents available by importing them back.
if you find that this table is really needed, ask the person who created this table to create a primary key, thus creating an index.
as Basis, you should not create a primary key as this is the job of the functional/abapper who created the table.
Please do not forget to provide feedback.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.