Skip to Content
0
Former Member
Mar 23, 2009 at 11:20 AM

Time out while reading single record from CRMD_ORDERADM_H table on OBJECTID

57 Views

Hi,

This is the problem i am facing in CRMD_ORDERADM_H.

if i search for a single record in CRMD_ORDERADM_H Table using SE11 on OBJECT_ID field, it is giving me Time out error.

CRMD_ORDERADM_H db size would be > 1 Billion records.

It is having a Secondary Standard index on OBJECT_ID.

If i search for single record with OBJECT_ID and PROCESS_TYPE i am able to get the result within seconds.

But if i take some range in OBJECT_ID and single value in PROCESS_TYPE then i am getting Time out erro.

we have index (custom) on OBJECT_ID and PROCESS_TYPE combination.

What would be the cause?

Thanks in Advance,

-Kishore