Re: Doing large sort in RAM - sort workarea manipulation

The most significant hints would be a leading() hint to ensure Oracle accessed the tables in the right order, and an index() hint to tell Oracle to walk through the appropriate driving index - but you'd still need a full set of hints to stabilise the path.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

• Original Message ----- From: "Grzegorz Goryszewski" <grzegorzof_at_interia.pl> To: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> Sent: Saturday, November 12, 2011 2:03 PM Subject: Re: Doing large sort in RAM - sort workarea manipulation

> If I stick with sort elimination by CBO (nosort operation) I can imagine there
> are hints needed , not sure CBO will use index with large output , so what
> kind of hints
> should be used to force NOSORT sort execution ?
> Regards
> GregG
>

--
http://www.freelists.org/webpage/oracle-l