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. Say, for example, if this statement
selectcountry_name, sum(AMOUNT_SOLD)from sales s, customers c, countries cowheres.cust_id=c.cust_idand co.country_id=c.country_idand country_name in ('Ireland','Denmark','Poland','United ...
