update stats after load

From: Thorsten M. Wahl <twahl3_at_compuserve.de>
Date: Thu, 10 Oct 2002 10:52:45 +0200
Message-ID: <ao3evn$27f$1@nntp-m01.news.aol.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 Received on Thu Oct 10 2002 - 03:52:45 CDT