Problem solve Get help with specific problems with your technologies, process and projects.

How to test queries before transport

This tip offers a quick way to test your queries before running in either QA or production environments.

There is a way to detect possible performance issues in the quality assurance or production environments before transport (authorization maybe required for production.) To test the impact of select queries, especially impact of joins on the database, write a query using transaction SQ01 with a required test condition in the target system (like QA). This should be done while writing big joins on large database tables like MARA, before the piece of code is transported to testing environment.
This was last published in October 2007

Dig Deeper on SAP ABAP

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close