create procedure sp_big_table()
begin
  declare i integer;
  declare stmt statement;

  prepare stmt from
  '
    select 1
    from information.tables
    where upper(name) = ''BIG_TABLE''
  ';
  execute stmt;
  if (rowsaffected(stmt) = 1) then
    execute immediate 'drop table big_table';
  end if;
  execute immediate
  '
    create table big_table
    (
      col1 integer generated by default as identity not null,
      col2 varchar(20) collate enu default ''col2 value ''||cast(col1 as varchar(7)),
      col3 varchar(20) collate enu default ''col3 value ''||cast(col1 as varchar(7)),
      col4 varchar(20) collate enu default ''col4 value ''||cast(col1 as varchar(7)),
      col5 varchar(20) collate enu default ''col5 value ''||cast(col1 as varchar(7)),
      col6 varchar(20) collate enu default ''col6 value ''||cast(col1 as varchar(7)),
      col7 varchar(20) collate enu default ''col7 value ''||cast(col1 as varchar(7)),
      col8 varchar(20) collate enu default ''col8 value ''||cast(col1 as varchar(7)),
      col9 varchar(20) collate enu default ''col9 value ''||cast(col1 as varchar(7)),
      col10 timestamp,
      constraint pk_big_table primary key (col1)
    )
  ';
  execute immediate 'create index ix_big_table_col10 on big_table (col10)';

  prepare stmt from 'insert into big_table (col10) values(timestamp''2007-03-19 17:00:28'')';
  set i = 0;
  repeat
    execute stmt;
    set i = i+1;
  until i = 10
  end repeat;

  prepare stmt from
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:00:28''
    from big_table
    where col1 <= 10
  ';
  set i = 0;
  repeat
    execute stmt;
    set i = i+1;
  until i = 9
  end repeat;

  prepare stmt from
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:00:28''
    from big_table
    where col1 <= 100
  ';
  set i = 0;
  repeat
    execute stmt;
    set i = i+1;
  until i = 9
  end repeat;

  prepare stmt from
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:00:28''
    from big_table
    where col1 <= 1000
  ';
  set i = 0;
  repeat
    execute stmt;
    set i = i+1;
  until i = 9
  end repeat;

  prepare stmt from
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:00:28''
    from big_table
    where col1 <= 10000
  ';
  set i = 0;
  repeat
    execute stmt;
    set i = i+1;
  until i = 9
  end repeat;

  prepare stmt from
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:00:28''
    from big_table
    where col1 <= 100000
  ';
  set i = 0;
  repeat
    execute stmt;
    set i = i+1;
  until i = 9
  end repeat;

  execute immediate
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:02:37''
    from big_table
    where col1 <= 1000000
  ';

  execute immediate
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:04:35''
    from big_table
    where col1 <= 1000000
  ';

  execute immediate
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:06:04''
    from big_table
    where col1 <= 1000000
  ';

  execute immediate
  '
    insert into big_table (col10)
    select timestamp''2007-03-19 17:07:47''
    from big_table
    where col1 <= 1000000
  ';

  unprepare stmt;
end
 