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: Help On Performance Issue

Re: Help On Performance Issue

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 10 May 2002 19:18:14 -0500
Message-ID: <uk7qbqsfj.fsf@rcn.com>


On Fri, 10 May 2002, mtwalla_at_bluefishgroup.com wrote:

> Why would the EXPLAIN PLAN differ, the same query is being run against
> both Databses?

Two quick guesses. The indexes don't exist on DB1. The tables aren't analyzed on DB1.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Fri May 10 2002 - 19:18:14 CDT

Original text of this message

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