Performance issue with view selection after migration from oracle to MaxDb

[Former Member]

Hello,

After the migration from oracle to MaxDb we have serious performance issues with a lot of our tableview selections.

Does anybody know about this problem and how to solve it ??

Best regards !!!

Gert-Jan

[Melanie]

Hello Gert-Jan,

most probably you need additional indexes to get better performance.

Using the command monitor you can identify the long running SQL statements and check the optimizer access strategy. Then you can decide which indexes might help.

If this is about an SAP system, you can find additional information about performance analysis in SAP notes 725489 and 819641.

SAP Hosting provides the so-called service 'MaxDB Migration Support' to help you in such cases. The service description can be found here:

http://www.saphosting.de/mediacenter/pdfs/solutionbriefs/MaxDB_de.pdf

http://www.saphosting.com/mediacenter/pdfs/solutionbriefs/maxDB-migration-support_en.pdf.

Best regards,

Melanie Handreck