Some of the SID tables take a lot of time to index eventhough the volume is less. Is there any setting that need to be done?
Here is the stat of two objects for example. The first record in each set is the initial indexing. Since the volume is high the indexing time is also high. The next three records are from roll-up. When you look at the second record of each set, eventhough the records inserted are in 100K, the TIMEREAD is high, almost half of the initial fill. The third and fourth records look normal.
Any reason?
Object TIMEREAD TIMEFILL TIMEOPTIMIZE TIMECOMMIT REC_INSERTED /BI0/SDOC_NUMBER 636.802779 8,925.103296 213.945719 4.974381 212,420,005 /BI0/SDOC_NUMBER 292.396420 9.711254 35.937065 9.993905 96,700 /BI0/SDOC_NUMBER 2.953143 9.756517 35.447003 4.818009 60,336 /BI0/SDOC_NUMBER 2.071610 9.126111 33.582829 2.396237 33,156 /BIC/SBORGDNUM 1,053.953314 2,013.676251 304.764505 6.752824 293,281,792 /BIC/SBORGDNUM 414.273110 13.336339 54.603681 8.372419 159,261 /BIC/SBORGDNUM 3.946742 13.359297 54.428974 5.025583 86,140 /BIC/SBORGDNUM 2.668379 13.195587 53.620421 4.440632 89,084