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

Home -> Community -> Usenet -> c.d.o.server -> Re: +Sort hint

Re: +Sort hint

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 06 Jul 1999 20:40:03 GMT
Message-ID: <37825f8e.904724@news.siol.net>


On Mon, 05 Jul 1999 20:27:56 -0400, Doug Cowles <dcowles_at_bigfoot.com> wrote:

>I was using an automated tuning tool that recommended I place the data
>into the
>table in sorted order, and then user a +Sort hint to expedite a query.
>
>I thought that Oracle pretty much returned the data any way it felt like
>it regardless
>of when I put it in. What good will pre-sorting data do?

I'm not aware of any hint named SORT or some other hint that would force the behavior you describe. If there is such a thing, I would be grateful for any reference/information. If ther isn't then the optimizer simply ignores your hint and treats it like an ordinary comment.

>- Dc.

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Jul 06 1999 - 15:40:03 CDT

Original text of this message

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