Isn't it good option to use partitioning if its 8+ version database since, you are trying to split that tabe on date. Just a thought....