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: NewBie question: 9i query runs slower than same query on 8i?

Re: NewBie question: 9i query runs slower than same query on 8i?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 29 Aug 2005 01:02:30 GMT
Message-Id: <pan.2005.08.29.01.02.30.107690@sbcglobal.net> 





On Sun, 28 Aug 2005 17:35:53 -0700, paulhux174 wrote:



> What do I need to change in 9i setup or configuration to get it to run

> the same as 8i.




Probaby, the execution plan of the statement in 9i. There are several ways 
how to do that. They include analyzing tables, creating stored outlines,
making sure that indexes are the same and, last and least,giving hints to
your SQL statements. 


-- 
http://www.mgogala.com


Received on Sun Aug 28 2005 - 20:02:30 CDT












Original text of this message













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