Skip to Content
0
Jan 19, 2012 at 02:27 PM

Why is the Read on Rollup slow?

35 Views

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