Re: Sort Algorithm

Oracle is not a sorting tool. True, you can build indexes based on any combination of fields to retrieve data quickly (relatively). If you need to quickly sort data, check out Syncsort. The company I work for, Comshare, requires our customers to buy Syncsort to front-end large data loads into Oracle, which our application uses as the database. Syncsort saves our customer many hours (days?) processing time. If Oracle tables are loaded in a sorted order, then your indexes may be build with the "no sort" option.

--Bob. (Rnightingale_at_comshare.com)

eaviles_at_ix.netcom.com wrote in message <6d6ver$rni$1_at_nnrp1.dejanews.com>...
>Hi
>
> Does anyone know what sorting algorithm Oracle uses in an ORDER BY
>clause? Is it quick sort? I'm asking because I want to decide
>whether to allow the DB to sort my data or select the data,
>then call qsort() (I'm using Pro*C).
>
> Just as there are books on UNIX internals, is there a book on
>Oracle internals?
>
> Please, reply by mail.
>
>Thanks,
>
>Enrique
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sun Mar 08 1998 - 00:00:00 CET