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 -> +Sort hint

+Sort hint

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Mon, 05 Jul 1999 20:27:56 -0400
Message-ID: <37814D8C.D6BF65EF@bigfoot.com>


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?

Received on Mon Jul 05 1999 - 19:27:56 CDT

Original text of this message

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