Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!news.stealth.net!news.stealth.net!ngpeer.news.aol.com!news.compuserve.com!news-master.compuserve.com!not-for-mail
From: "Thorsten M. Wahl" <twahl3@compuserve.de>
Newsgroups: comp.databases.oracle.server
Subject: update stats after load
Date: Thu, 10 Oct 2002 10:52:45 +0200
Organization: CompuServe Interactive Services
Lines: 19
Message-ID: <ao3evn$27f$1@nntp-m01.news.aol.com>
NNTP-Posting-Host: ns.dhag.de
X-Trace: nntp-m01.news.aol.com 1034239799 2287 194.25.216.2 (10 Oct 2002 08:49:59 GMT)
X-Complaints-To: newsmaster@compuserve.com
NNTP-Posting-Date: Thu, 10 Oct 2002 08:49:59 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163698
X-Received-Date: Thu, 10 Oct 2002 01:50:18 MST (news.easynews.com)

Hello.

I'm using 8.0.3 EE and need to load data into a table using Sqlldr80.exe.
If I use the (new) CBO I need to update the stats after the load has
finished using "Analyze". Is this correct? Is there a faster way to keep the
stats up to date?

I also remove all the data from the tables when finished a few queries on
the loaded data. Should I also remove the stats then?

At the moment I'm still using the RBO so there is no need for stats.

Isn't it faster to stick with RBO in this case?

TIA
Thorsten