Temp table is no different from regular tables. We may choose either page or extent allocation to optimize performance and space utilization. The kinds of operation affect how we choose: select into bulk insert create index insert How full the tables