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: Full table scan query

Re: Full table scan query

From: John Darrah <jdarrah_at_veripost.net>
Date: Tue, 22 Jan 2002 19:23:27 +0000 (UTC)
Message-ID: <0f125186bee8d2a40200ee1b06cd05f3.36240@mygate.mailgate.org> 





Have you tried setting your optimizer mode to first_rows or using the
first_rows hint?  You could also try the rule hint if it still uses a
FTS with the rule hint look for an implicit datatype conversion going
on.




-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG


Received on Tue Jan 22 2002 - 13:23:27 CST












Original text of this message













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