Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: More help on sort
Hello Steve,
Thanks for the info. But which column of plan table tells me "DISK SORT" (and not memory sort) is taking place. For example, I have the following plan here. Does "operation" column with SORT operation always means disk sort?
OPERATION OPTIONS OBJECT_NAME POSITION ID ------------------------------ ------------------------------ ------------------------------ ---------- ---------- CREATE INDEX STATEMENT 210255 0 INDEX BUILD UNIQUE TEST 1 1 SORT CREATE INDEX 1 2 INDEX FAST FULL SCAN COMMERCIAL_AGING_PK 1 3
And if somebody can tell me the criteria to decide whether sort_area_size is optimised or not that will help me a lot. Received on Fri Nov 10 2000 - 08:36:49 CST