Oh OK

somehow ive picked this up wrong. I was under the impression that partitioning the data would give benefit in the form of sql server not having to look at the older data. So for my case of 50 million records, would i be better to re-index the table on the date field?