Re: ORACLE SORT

You can sort on columns that are not indexed. The sort happens after the data is retrieved. The only time I can think that an index would help is if the index contained all the columns in the query and the order by clause. What will effect performance is the sort_area_size and the retained_sort_area_size parameters. If they are too small then Oracle will have to sort to disk which is much more expensive than sorting in memory. Jim

"SATYA PAL" <spgangwar_at_yahoo.com> wrote in message news:a7b8a58b.0106081044.3ddc0183_at_posting.google.com...
> Hi,
>
> Any idea how Oracle Sort works?
>
> I have a requirement to sort on columns which are not indexed. I am
> not sure whether that will impact the performance. Should I define the
> index on the columns which are being used as a part of the sort.
>
> Please explain.
>
> Regards
> Satya Pal
> IBIS Project
> ACBL Technology Division
> 1-812-288-1943 (W) Ext 2943
> 1-502-568-2807 (H)
> Efax &#8211; 1-413-513-5725
Received on Sat Jun 09 2001 - 01:00:05 CEST