Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Partitioning OCP Question

Partitioning OCP Question

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: 2000/03/04
Message-ID: <0Edw4.2451$B37.209017@bgtnsc06-news.ops.worldnet.att.net>#1/1 






I am baffled by the following question, whose answer is B.  Can someone tell
me the connection between partitioning and temporary sort segments?  Aren't
only the rows returned by a query sorted, irrespective of the size of the
tables from whence they came?



Which Oracle8 feature can reduce the size of temporary tables used for
sorting large tables.



    
  
  1.   VARRAYS

  
  2.   Partitioning
  
  3.   Large Pool
  
  4.   Multiplexing.



Received on Sat Mar 04 2000 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US