Archiving - Performance

[Former Member]

Hi Friends,

We had Archived FI data for year 2005 for a table

When we run the select query for that table for year 2005 , it is taking lot of time , around 60,000 secs

When we run for 2006,2007 and 2008 , select query is completed within 120 secs

I would like to know if write select query on table which is archived for an year, will it effect any performance?

Thanks

Chandra

[Former Member]

Hi Friends,

We had Archived FI data for year 2005 for a table

When we run the select query for that table for year 2005 , it is taking lot of time , around 60,000 secs

When we run for 2006,2007 and 2008 , select query is completed within 120 secs

I would like to know if write select query on table which is archived for an year, will it effect any performance?

Thanks

Chandra

[Former Member]

i think for year 2005 table has large data thatts why it is takin lot of time.

[Former Member]

Hi

Check the where condition of the SELECT statement.

Also check the table for no of entries for each year.

Regards

Shiva

[Former Member]

Thanks Guys for the replies

It looks the problem is with basis,

They have to update the statistics after Archiving

Will let you know the exact answer

Thanks

Chandra

[Former Member]

Hi Chandra,

I am also in a archiving project and would like to know which statistics you are talking about. Please provide some information so I can also get it done for my project.

Also I am facing some in COPA data archiving, while using COPA1_XXXX object its took 95 hrs to runt he job and resulted in cancellation of the job. I have activated index 3 for table CE1XXXX. If you know some thing on COPA archiving please tell me.

Regards,

Shailesh