performance create table vs Temp table

Hi all, I have an sql that makes use of many small temp tables. ie: select id1 from tab1 where id2 >20 into temp idlist with no log; Would it be more efficient to make these permanent tables, and run a delete after each use. ( this query is only run by one user at a time ! ) Thanks, Isaac ______________________________ Isaac Loven.