Hi ,
I have a partitioned table with 135 columns and 101 partitions which is part of a data warehouse reporting application. Each partition has about 4.5M records and keeps growing slowly - the space usage per partition is about 7 G. The table also has 3 indexes :
1 - PK index
1 - local index on partition column
1 - local index on column used while filtering data in a frequently used query.
The process to load data into the table happens once everyday and a new partition is created with each load on a daily basis. The stats are gathered immediately after the days load and the table preference is set set to INCREMENTAL , TRUE.
We are seeing that this gather stats activity is taking almost 30 mins to complete. Is there any thing that anyone can recommend to shorten the time taken to complete the gather stats task a little faster. Has anyone see this kind of slowness and what have you done to increase its speed.
Please let me know if you need any further info from my end.
Thanks,
Sai