Temp tablespace - system or user?

Question posted by: Arun Srinivasan (Guest) on July 1st, 2008 08:35 PM

I have a sql that goes like

select ............... from table (select ....... from table t where
<>) as x

Now this temp table x is supposed to keep 10 K rows at a point of
time. Where would they be stored? I know the answer is temp
tablespace, but is it in system temp or user temp?
All I am trying to do is to create a temp (sys or user) with good
amount of pages so that these kinds of queries would speed up. I dont
know the size of which I'd have to create (16, 32k) ? How can we
estimate this so that I can create a system temp space wth 10 gigs.

Please help in defining them.

Ever questioning ,
Arun

Not the answer you were looking for? Post your question . . .
189,285 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).