FPSAPP.BLD_SAILBOAT_MULTIPLE_TABLES

>

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_SAILBOAT_MULTIPLE_TABLES

This view saves a useful semi-automated sailboat racing technique where we create a temp table and then insert rows into it within a begin/end statement so we know we have to query each row and we are not affected by connection speed. The concern with this technique is that we are only selecting a few columns and Oracle is smart about this so it might be slower to select all columns. --create empty table create table aaa_sailboat# as select lot, carrier, prd as table_name, prd as filter_by, systimestamp as ts, est_end_tool_reason as col1, process_state_inst as col2 from wip_lots_plus where 0=1; --generate the query, copy the first 30 lines to paste into next part use the query in this view --Paste first 30 lines (5 of each) wrapped by begin/start and end/end begin delete from test_speed#; insert into aaa_sailboat# values ('START', 'START', 'START', 'START', systimestamp, null, null); past 30 lines here; insert into aaa_sailboat# values ('END', 'END', 'END', 'END', systimestamp, null, null); commit; end; --Summarize the results select table_name, filter_by, avg(d), min(d), max(d), count(*) from ( select timestamp_delta_sec(ts, lead(ts) over (order by ts)) as d, t.* from aaa_sailboat# t ) where table_name not in ('START','END') group by table_name, filter_by order by 1, 2; --Drop table when finished drop table aaa_sailboat#;