declare global temporary table xx
(
id int,
name varchar(200)
)
on commit preserve rows not logged with replace;
insert into session.xx values(1,'sdfsdfs');
insert into session.xx values(1,'sdfsdfs');
insert into session.xx values(1,'sdfsdfs');
create index session.xxxx on session.xx(id);
select * from session.xx where id=1;
(
id int,
name varchar(200)
)
on commit preserve rows not logged with replace;
insert into session.xx values(1,'sdfsdfs');
insert into session.xx values(1,'sdfsdfs');
insert into session.xx values(1,'sdfsdfs');
create index session.xxxx on session.xx(id);
select * from session.xx where id=1;