Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition

© Stelios Charalambides  2017

Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_16

16. Building Good Test Cases

Stelios Charalambides¹ 

(1)New Hampton, New Hampshire, USA

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

select  country_name, sum(AMOUNT_SOLD)from sales s, customers c, countries cowhere  s.cust_id=c.cust_id  and co.country_id=c.country_id  and country_name in (    'Ireland','Denmark','Poland','United ...