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