Home » SQL & PL/SQL » SQL & PL/SQL » Analyze Tables (Oracle 9i)
Analyze Tables [message #296112] Thu, 24 January 2008 11:38 Go to next message
ravichandran_123
Messages: 13
Registered: October 2007
Location: Bangalore
Junior Member
Hi,

We load the data from flat file to database table in a sequential loading method (No bulk load). After that the data will be processed in record by records using a cursor for validating each and every record based on different business rules.

Since its a cursor based processing, I agree that the run time will be more. But when I look at the table stats, I see that the table last analyzed was 1.5 years back. So my concern is, if I have a job which analyzes by table frequently before the load and processing job kicks-off, will that improve the run-time of the process?

Please advise..

Thanks,
Ravi
Re: Analyze Tables [message #296143 is a reply to message #296112] Thu, 24 January 2008 19:47 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
That depend on your data and programs.

Some changes to the data make the optimal execution plans change, others don't.

Really, the only way to know is to gether stats and see if the performance improves.

A general rule-of-thumb is to keep stats up-to-date.

Ross Leishman
Re: Analyze Tables [message #296179 is a reply to message #296112] Fri, 25 January 2008 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you take all the rows of a table row by row and check against indexed column, statistics are useless.

Regards
Michel
Re: Analyze Tables [message #297672 is a reply to message #296179] Sat, 02 February 2008 04:53 Go to previous messageGo to next message
ravichandran_123
Messages: 13
Registered: October 2007
Location: Bangalore
Junior Member
Thanks Mike for the reply. So in this scenario that I explained, analyzing the tables wouldn't make much difference on the performance, right?

Thanks,
Ravi
Re: Analyze Tables [message #297691 is a reply to message #297672] Sat, 02 February 2008 09:35 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't answer to this question because I don't know what you will do with it.

Regards
Michel
Previous Topic: inserting
Next Topic: Grant permission
Goto Forum:
  


Current Time: Sun Dec 04 23:05:35 CST 2016

Total time taken to generate the page: 0.23794 seconds