on 03-09-2010 3:47 PM
Experts,
I'm looking through the operations guide for TDMS and notes related to peformance , Note 1256679 - Long runtime in VBUK_2 if VBELN in table VBFA has no index specifically says:
Create index on table VBFA:
ideally, by creating an index as follows:
Mandt
VBELN
VBELV
POSNV
So even though I'm at the latest levels on DMIS:
DMIS 2006_1_700 0013 SAPK-61713INDMIS
DMIS_CNT 2006_1_700 0013 SAPK-61713INDMISCNT
DMIS_BSC 2008_1_700 0005 SAPK-81705INDMISBSC
DMIS_EXT 2007_1_700 0007 SAPK-71707INDMISEXT
DMIS_HR 2008_1_700 0004 SAPK-81704INDMISHR
Do you think this index should be set?
Thanks Nick
Hello NIck,
The Correction of the SAPnote that you mentioned are delivered with the old support packages but the manual steps that is explained regarding the index will still be very helpfull in increasing the performance.
Best Regards
Niraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
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.