create temporary table x on commit drop as
select ....

create index on x(some_column);