Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news1.rdc1.sdca.home.com.POSTED!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: query performance
From: Ban Spam <ban-spam@operamail.com>
References: <9q2buh$7bp@dispatch.concentric.net> <9q2imj$7bj@dispatch.concentric.net>
Organization: Black Hole, Inc.
Message-ID: <Xns9136B18222061SunnySD@24.0.3.73>
User-Agent: Xnews/4.06.22
Lines: 29
Date: Thu, 11 Oct 2001 00:27:00 GMT
NNTP-Posting-Host: 24.16.103.228
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc1.sdca.home.com 1002760020 24.16.103.228 (Wed, 10 Oct 2001 17:27:00 PDT)
NNTP-Posting-Date: Wed, 10 Oct 2001 17:27:00 PDT
Xref: easynews comp.databases.oracle.server:120881
X-Received-Date: Wed, 10 Oct 2001 18:02:57 MST (news.easynews.com)

"Jim Poe" <jpoe@fulcrumit.com> wrote in
news:9q2imj$7bj@dispatch.concentric.net: 

> Hi,
> 
> I did an explain plan for each database.
> 
>                 Test                        Devl
> Cost    379431                    7048
> Card    359135                    4969
> Bytes    181363175            5371489
> 
> 
> Why would there be such a substantial difference between the two
> databases? 
> 
> --
> Jim Poe (jpoe@fulcrumit.com)
> 
> 

Given the fact that you get a COST in both plans,
it appears that you are using the CBO. Therefore
try ANALYZE TABLE _____ COMPUTE STATISTICS;
against all the table involved on the TEST instance.
Then re-run the query.

It might be helpful if you posted the WHOLE explain
plans from both & not just the summary.