Home » RDBMS Server » Performance Tuning » Analyze before insert - does it help
Analyze before insert - does it help [message #187739] Tue, 15 August 2006 05:45 Go to next message
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
Member
Hi all,

I'm using an ETL tool to load staging tables that are then used as sources for future query's.

At the beginning of the job I truncate the tables. I analyze then after the load to provide up to data statistics when they are used as a source for the next query.

My question is, should I analyze the newly truncated staging tables before I load them, will that help with the performance of the load. After load I have 2.2 million rows which remain till the next run.

I'm on Oracle 9i running on Solaris.

Cheers

Allie
Re: Analyze before insert - does it help [message #187742 is a reply to message #187739] Tue, 15 August 2006 06:06 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>should I analyze the newly truncated staging tables before I load them
No need.
Previous Topic: Need help on explain plan
Next Topic: Dictionary Managed to Locally Managed Tablespace
Goto Forum:
  


Current Time: Fri Dec 09 17:51:22 CST 2016

Total time taken to generate the page: 0.12739 seconds