i have 3yrs (2011,2012,2013)of data in the application while doing the incremental load 1 more year (2014)data is added now the performance is reduced so any options to increase the performance. if i do the same function (adding 1yr (2015)more)again data will increase performance will reduce any suggestions.
