Building Good Test Cases

  • Stelios Charalambides


Occasionally there are tuning problems where the solution is not obvious from the examination of the SQLTXTRACT or SQLTXECUTE report. All the usual suspects have been eliminated and a more thorough investigation may be required. In cases like these it is useful to build a test case to allow experimentation away from the main environment. If you are investigating a problematic SQL in a test environment, normally you would try and make the environment the same as the environment you are attempting to replicate. This is often very difficult to do because there are many factors affecting an environment that need to be copied. Here are some of them.


Test Environment Execution Plan Package Body Schema Object Press Enter 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Stelios Charalambides 2013

Authors and Affiliations

  • Stelios Charalambides

There are no affiliations available

Personalised recommendations