on 05-04-2010 11:13 PM
Hi All,
Due to performance related issues in our liveCache system, I found that we have 0 indexes defined on /sapapo/ordkey in our liveCache maxdb database. I've seen notes to create additional secondary indexes, but I'm curious: what is the primary index definition supposed to be? We're on 7.7.04.36, SCM 5.1 (SCM 2007)
Thanks for your help!
Margaret
hi Margaret,
Did you recently upgrade to SCM 5.1? SAP note 957031 maybe of interest to you.
Anyway, this is how you look for a primary key (primary index) and secondary key (secondary index) via LC10 -
LC10 -> Problem Analysis -> Logs -> Tables/views/Synonyms
Database Object Schema SAP<sid>
Name of Database Object /SAPAPO/ORDKEY
- under the <Definition> tab, look for 'Type' column = KEY. Columns with Type KEYS make up the primary key.
- under the <Index> tab, secondary indexes are listed, if any.
SAP note 928037: FAQ: SAP MaxDB indexes
Above note is really good ... It's an FAQ note on indexes which also defines some terminology diff.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Junco,
Thx for your information. I'm a little bit confused about the LC-related indices. Why can't we find the indices(i.e. secondary indices via calling BAPI) in SE11? I mean, after implementing the BAPI given from NOTE 749824-secondary index on table /SAPAPO/ORDKEY, there's no index can be seen from SE11 but LC10 -> Problem Analysis -> Logs -> Tables/views/Synonyms.
Is such index which is related to table /SAPAPO/ORDKEY created in the memory but not MaxDB?
Or could you please explain this phenomenon?
BRs,
Deacon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Junco! That was the information I needed.
Kind Regards,
Margaret
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Junco! That was the information I needed.
Kind Regards,
Margaret
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.