Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioning OCP Question
Without using the partition, the whole table might be sorted, partition can eliminate those other partitions which do not include the data you are querying, so the correct answer is B.
Zhenming
Buck Turgidson wrote in message
<0Edw4.2451$B37.209017_at_bgtnsc06-news.ops.worldnet.att.net>...
>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.
>
>A. VARRAYS
>B. Partitioning
>C. Large Pool
>D. Multiplexing.
>
>
Received on Sat Mar 04 2000 - 00:00:00 CST