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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle(r) Database 10g Release 2 and much faster sorting

Re: Oracle(r) Database 10g Release 2 and much faster sorting

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 14 Dec 2004 00:40:51 +0200
Message-ID: <009201c4e164$d4cd73b0$6ff923d5@porgand>


> 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.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 13 2004 - 16:38:12 CST

Original text of this message

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