on 06-04-2008 12:14 PM
Hi
I've noticed in the results of the DBCHECK job in DB13 that we have a number of warnings for missing indexes.
BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BI0/PCOSTELMNT
The strange thing is that no missing indexes are picked up be DB02. In SE11 these tables cannot be found. Checked at Oracle level and the tables exist but the indexes do not.
Does anyone know if these tables should have indexes?
If so what would be the best way to create these?
Thanks & Regards
Shishir
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In DB02 they are probably showing under 'Optional Indexes' under 'not created'
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 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.