FPSINPUT.BLD_SAILBOAT_SINGLE_TABLE

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_SAILBOAT_SINGLE_TABLE

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. As opposed to the multiple table version, this technique queries all non-empty columns so it is a test of the real speed and is not affecting by Oracle being smart about selecting only a few columns. --get list of non-empty columns select get_tab_col_list('wip_lots_plus', 'Y') from dual; --create empty table create table aaa_sailboat# as select systimestamp as ts, paste_non_empty_col_list_here 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#;