Re: Doing large sort in RAM - sort workarea manipulation
Date: Sat, 12 Nov 2011 17:47:59 -0000
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.
- 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 ?