oysteing@idt.unit.no (Oystein Groevlen) (12/10/90)
I tried posting this last week, but it seems like it never left my terminal. We are using ORACLE version 6.0.27 on an 386-machine with ISC Unix. The Database Administrator's Guide says that temporary segments are used for unindexed joins (among other things). We are thinking of making a separate tablespace for temporary segments. My question is how to estimate how large the database file for this tablespace needs to be. I guess this depends on the size of the RAM, so maybe the question should be how much virtual memory is needed. Is there a general formula for estimating the space needed for an unindexed join based on the size of the tables involved? In our case we have two tables. Table A has 86415 rows of 50 byte each and table B has 345660 rows of 57 bytes. How big a temporary segment is needed for an unindexed join of A and B? What about a unindexed join of four B (selfjoin)? Any advice and/or comments are appreciated. -- ======================================================================= Oystein Groevlen Division of Computer Systems and Telematics The Norwegian Institute of Technology The University of Trondheim Email: oysteing@idt.unit.no =======================================================================