30 lines
645 B
MySQL
30 lines
645 B
MySQL
drop table t;
|
|
|
|
create table t as select rownum a, 'zzz' b from dual connect by level<=1000;
|
|
|
|
create index i on t(a);
|
|
|
|
exec dbms_stats.gather_table_stats(user,'T',method_opt=>'FOR COLUMNS A SIZE 254');
|
|
|
|
@sqlt "select * from t where a ="
|
|
|
|
|
|
alter session set cursor_sharing = similar;
|
|
|
|
spool c:\tmp\lotsofselects.sql
|
|
|
|
select 'select * from t where a = '||rownum||';' from dual connect by level<=10;
|
|
|
|
spool off
|
|
|
|
@c:\tmp\lotsofselects.sql
|
|
@hash
|
|
|
|
|
|
@sqlt "select * from t where a ="
|
|
|
|
--exec for i in 1 .. 10000 loop execute immediate 'delete t where a = '||to_char(i); end loop;
|
|
--declare j number; begin for i in 1..1000 loop select count(*) into
|
|
|
|
|