03-10-2009 4:40 PM
Hello All,
The index tables of SD like VAKPA and VAPMA as I understand are special tables where Sales data is stored and indexed by partner function or material. My question is, is there any logic or advantage in declaring more indexes on these type of tables? For e.g. a index on VAKPA with sales doc number!
Do you think this really is advised and are there any possible impacts?
Thanks in advance for your help.
Best Regards
Anirban
03-10-2009 5:08 PM
Hi,
Firstly,
Creating more number of indexes on a table will lead to problems in selection of the proper index.
Index should be created for those fields which are majorly used in the queries so that the search is optimized...
If the indexes are already available then you should try to use them as far as possible,
if its required then you can create your own index
Regards,
Siddarth
03-10-2009 5:13 PM
Hello
Thanks for your reply, but I can understand that for a normal table, in case of VAKPA, it is an index table hence my question, whether any further index on VAKPA is advisable or not.
Thanks and Regards
Anirban
03-10-2009 5:19 PM
Hi,
Further index on an indexed table is not advisable
Regards,
Siddarth