Skip to Content
0
Former Member
Jan 20, 2009 at 06:22 PM

Archiving - Performance

48 Views

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