临时表，索引

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;