This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Please help: When should I analyze tables in oracle?The situation is like this:
A bunch of tables don't have too much data at very beginning. Then I analyze them all and run my program to load a large amount of data(over 80K records) into tableA. There is another program needs to be run to load data into tableB which is going to do complex join with tableA. To achieve better performance, I used hint in sql and cost based optimizer. My question is do I need to re-analyze the tableA after the data is loaded into tableA before processing tableB? Thanks
-tongcd(不明真相的总是群众);
2003-7-9
{507}
(#1277265@0)
-
yes
-bluelotus(时光漫步);
2003-7-9
(#1277711@0)
-
Thanks. You are right and I found the reference from oracle site"New statistics should be gathered after a schema object's data or structure are modified in ways that make the previous statistics inaccurate. For example, after loading a significant number of rows into a table, you should collect new statistics on the number of rows."
-tongcd(不明真相的总是群众);
2003-7-10
{274}
(#1278727@0)