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