/* 
Name:		silver_bullet.sql

Date:		

Purpose:	Script to illustrate Silver Bullet dangers

*/
set echo off
set timing off
prompt 'Set o_i_c_a default'
@set_session_parameter optimizer_index_cost_adj 100
set timing on
prompt 'Adjust o_i_c to 0'
@set_session_parameter optimizer_index_caching  0
@sql2
prompt 'Adjust o_i_c to 25'
@set_session_parameter optimizer_index_caching  25
@sql2
prompt 'Adjust o_i_c to 50'
@set_session_parameter optimizer_index_caching  50
@sql2
prompt 'Adjust o_i_c to 75'
@set_session_parameter optimizer_index_caching  75
@sql2
prompt 'Adjust o_i_c to 100'
@set_session_parameter optimizer_index_caching  100
@sql2
prompt 'Adjust o_i_c_a to 75'
@set_session_parameter optimizer_index_cost_adj  75
@set_session_parameter optimizer_index_caching  0
@sql2
prompt 'Adjust o_i_c to 25'
@set_session_parameter optimizer_index_caching  25
@sql2
prompt 'Adjust o_i_c to 50'
@set_session_parameter optimizer_index_caching  50
@sql2
prompt 'Adjust o_i_c to 75'
@set_session_parameter optimizer_index_caching  75
@sql2
prompt 'Adjust o_i_c to 100'
@set_session_parameter optimizer_index_caching  100
@sql2
prompt 'Adjust o_i_c_a to 50'
@set_session_parameter optimizer_index_cost_adj  50
@set_session_parameter optimizer_index_caching  0
@sql2
prompt 'Adjust o_i_c to 25'
@set_session_parameter optimizer_index_caching  25
@sql2
prompt 'Adjust o_i_c to 50'
@set_session_parameter optimizer_index_caching  50
@sql2
prompt 'Adjust o_i_c to 75'
@set_session_parameter optimizer_index_caching  75
@sql2
prompt 'Adjust o_i_c to 100'
@set_session_parameter optimizer_index_caching  100
@sql2
prompt 'Adjust o_i_c_a to 25'
@set_session_parameter optimizer_index_cost_adj  25
@set_session_parameter optimizer_index_caching  0
@sql2
prompt 'Adjust o_i_c to 25'
@set_session_parameter optimizer_index_caching  25
@sql2
prompt 'Adjust o_i_c to 50'
@set_session_parameter optimizer_index_caching  50
@sql2
prompt 'Adjust o_i_c to 75'
@set_session_parameter optimizer_index_caching  75
@sql2
prompt 'Adjust o_i_c to 100'
@set_session_parameter optimizer_index_caching  100
@sql2
prompt 'Adjust o_i_c_a to 1'
@set_session_parameter optimizer_index_cost_adj  1
@set_session_parameter optimizer_index_caching  0
@sql2
prompt 'Adjust o_i_c to 25'
@set_session_parameter optimizer_index_caching  25
@sql2
prompt 'Adjust o_i_c to 50'
@set_session_parameter optimizer_index_caching  50
@sql2
prompt 'Adjust o_i_c to 75'
@set_session_parameter optimizer_index_caching  75
@sql2
prompt 'Adjust o_i_c to 100'
@set_session_parameter optimizer_index_caching  100
@sql2