How to test queries before transport
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.
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial Director
Dig Deeper
-
People who read this also read...
This was first published in October 2007