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: Does selecting a primary key column in select , from a table do an automatic order by

Re: Does selecting a primary key column in select , from a table do an automatic order by

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 10 Feb 2006 10:53:35 -0800
Message-ID: <1139597615.587671.72730@z14g2000cwz.googlegroups.com> 





RaviAlluru wrote:


> SELECT  /*+ FIRST_ROWS */



I would be very surprised if a FIRST_ROWS hint improved performance of
a join of four large tables. Surely full scans and hash joins would be
more efficient?



What happens if you analyze the tables and remove all the hints?
Received on Fri Feb 10 2006 - 12:53:35 CST












Original text of this message













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