RE: More help on sort

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sat, 11 Nov 2000 01:54:42 +1000
Message-Id: <10676.121709@fatcity.com>

Hi Shivaswamy,

The "cost" implies whether the optimizer expects a disk sort to be required and whether it thinks that additional merge phases will be required. Of course, you need to be using the CBO.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Raghunath, Shivaswamy [mailto:Shivaswamy.Raghunath_at_qwest.com] Sent: Saturday, 11 November 2000 0:37

Hello Steve,

... which column of plan table tells me "DISK SORT" (and not memory sort) is taking place. ... Received on Fri Nov 10 2000 - 09:54:42 CST