-
performance degradation after analyze table
Hi all,
We are using RBO for all selects.
We have one unix job that truncates a table ..say A..and reloads data into it using sql loader.(around 6 million records)
then another job runs that uses data from this table.
At fisrt we found that when the 2nd job runs, is doesnt use the index present in table A and does a FTS.Due to this, the 2nd job runs slow.
Then we added an additional analyze command as:
ANALYZE TABLE A estimate statistics sample 7 percent for table for all indexes;
still, the 2nd job ran slow.
Then we opted for deleting the stats using
ANALYZE TABLE A delete statistics;
after this, the 2nd job ran fast. Now our main concern is do we need to analyze the table A again...after the completion of 2nd job..becuase we are not sure if after analyzing the table, a 3rd job that uses table A would use the indexes or do a FTS.
Also why did the 2nd job run slow after analyze?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|