Re: Oracle(r) Database 10g Release 2 and much faster sorting
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Dec 2004 00:40:51 +0200
> EC> But how does Oracle plan to "speed up" sorts?
>
> My guess would be that they've come up with some new
> algorithms that are more efficient, or, at least, they
> believe those new algorithms to be more efficient under most
> circumstances.
Just guessing here, but it might also that Oracle picks the most optimal
algorithm based on estimated data (using optimizer statistics, execution
statistics and dynamic sampling...)
Tanel.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
