Skip to Content
0
Former Member
Feb 19, 2009 at 02:15 PM

Taking huge time to fetch data from CDHDR

58 Views

Hi Experts,

To count the entries in CDHDR table it taking huge time and throught time_out dump.

I hope in this table some more than million entries exist. Is there any alternate to findout the entries?.

We are finding the data from CDHDR by following conditions.

Objclass - classify.

Udate - 'X' date

Utime - 'X' (( even selecton 1 Min))

We also tried to index the UDATE filed but it takes huge time ( more than 6 Hrs and uncomplete)

Can you suggest us is there any alternate to find the entries.

Regards,

VS