Skip to Content
0
Sep 14, 2023 at 07:36 AM

Creating index on system table

47 Views

Hi,

To improve performance (considerably) of a view that combines data from OITM with a similar table in another database, I would have to create an index on OITM.

15 years ago, SAP policy was that you were allowed to do so with approval from SAP Business One Support.

In a 10 year old post here on the forum, the answer was simply that it is not allowed (on system tables), just like perfoming update and delete queries.

Does anybody know what the current policy is on adding indexes to system tables?

Regards,

Johan