Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newshosting.com!nx01.iad01.newshosting.com!news.glorb.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: bdbafh@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Performance problem: anything else I can do to make this faster?
Date: 3 Mar 2005 13:50:35 -0800
Organization: http://groups.google.com
Lines: 11
Message-ID: <1109886635.572153.26420@f14g2000cwb.googlegroups.com>
References: <1109793882.803053.240440@l41g2000cwc.googlegroups.com>
   <1109799052.789107.250590@o13g2000cwo.googlegroups.com>
   <00fc2196m32dguelv7p3uqbqbdla0unnvi@4ax.com>
   <1109805174.099516.303550@f14g2000cwb.googlegroups.com>
   <1109805606.965366.268740@o13g2000cwo.googlegroups.com>
   <1109871953.020529.138170@o13g2000cwo.googlegroups.com>
   <jsoe2191e2ean1g1iren3odme8em5bh4rr@4ax.com>
   <1109886332.669618.34910@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 156.43.4.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1109886640 3770 127.0.0.1 (3 Mar 2005 21:50:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2005 21:50:40 +0000 (UTC)
In-Reply-To: <1109886332.669618.34910@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=156.43.4.1;
   posting-account=rcQZawwAAAALUCo-zZUVUQgj4l_8W6zb
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237404

did you gather statistics on the tables and indexes afterwards?

when you create an index, you can add the "compute statistics" clause
on the end.
otherwise, exec
dbms_stats.gather_table_stats(ownname=>user,tabname=>'<table_name>,cascade=>true);

will do the job.

-bdbafh